[Solved] You created this trigger but it does not run when you insert data:CREATE TRIGGER log_insert AFTER INSERT ON sales EXECUTE FUNCTION log_sale();What is the likely problem? | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

You created this trigger but it does not run when you insert data:

CREATE TRIGGER log_insert AFTER INSERT ON sales EXECUTE FUNCTION log_sale();

What is the likely problem?

AAFTER INSERT triggers cannot be created

BTrigger function name is incorrect

CMissing FOR EACH ROW clause in trigger definition

Dlog_sale() function must return void

Step-by-Step Solution

Solution:

Step 1: Check trigger syntax requirements
PostgreSQL requires FOR EACH ROW or FOR EACH STATEMENT clause in CREATE TRIGGER statement.
Step 2: Identify missing clause in given trigger
The trigger lacks FOR EACH ROW or FOR EACH STATEMENT, so it is invalid and will not run.
Final Answer:
Missing FOR EACH ROW clause in trigger definition -> Option C
Quick Check:
Triggers need FOR EACH ROW/STATEMENT clause [OK]

Quick Trick: Always include FOR EACH ROW or STATEMENT [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You created this trigger but it does not run when you insert data: