[Solved] What is the main purpose of an AFTER trigger in PostgreSQL? — Ans: To execute a function after the main database operation completes successfully | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

What is the main purpose of an AFTER trigger in PostgreSQL?

ATo execute a function after the main database operation completes successfully

BTo prevent a database operation from happening

CTo execute a function before the database operation starts

DTo rollback the transaction if an error occurs

Step-by-Step Solution

Solution:

Step 1: Understand the timing of AFTER triggers
AFTER triggers run only after the main database action (INSERT, UPDATE, DELETE) has completed successfully.
Step 2: Identify the purpose of AFTER triggers
They are used to perform actions like logging or notifications after the main operation finishes.
Final Answer:
To execute a function after the main database operation completes successfully -> Option A
Quick Check:
AFTER trigger = runs after operation [OK]

Quick Trick: AFTER triggers run only after successful main actions [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What is the main purpose of an AFTER trigger in PostgreSQL?