[Solved] Identify the error in this trigger function:CREATE FUNCTION trg_wrong() RETURNS trigger AS $ BEGIN PERFORM some_nonexistent_function(); RETURN NEW; END; $ LANGUAGE plpgsql; | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

Identify the error in this trigger function:

CREATE FUNCTION trg_wrong() RETURNS trigger AS $$ BEGIN PERFORM some_nonexistent_function(); RETURN NEW; END; $$ LANGUAGE plpgsql;

AThe function calls a nonexistent function causing runtime error

BThe function should return void, not trigger

CThe language should be SQL, not plpgsql

DThe function is missing a RETURN statement

Step-by-Step Solution

Solution:

Step 1: Check function calls inside trigger
The function calls some_nonexistent_function(), which does not exist and causes an error.
Step 2: Verify return type and language
Return type trigger and language plpgsql are correct for trigger functions.
Final Answer:
The function calls a nonexistent function causing runtime error -> Option A
Quick Check:
Calling undefined function = runtime error [OK]

Quick Trick: Ensure all called functions exist in trigger code [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this trigger function: