[Solved] In PostgreSQL, what is the primary function of an INSTEAD OF trigger defined on a view? — Ans: It intercepts data modification commands on the view and executes specified... | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

In PostgreSQL, what is the primary function of an INSTEAD OF trigger defined on a view?

AIt automatically updates the underlying tables without any user-defined function.

BIt intercepts data modification commands on the view and executes specified actions instead of the default behavior.

CIt prevents any data modification on the view by raising an error.

DIt duplicates the data modification commands to all tables in the database.

Step-by-Step Solution

Solution:

Step 1: Understand the role of INSTEAD OF triggers
INSTEAD OF triggers on views allow intercepting INSERT, UPDATE, or DELETE commands on the view.
Step 2: What happens when the trigger fires?
Instead of the default behavior (which is not allowed on views), the trigger executes a user-defined function to handle the operation.
Final Answer:
It intercepts data modification commands on the view and executes specified actions instead of the default behavior. -> Option B
Quick Check:
INSTEAD OF triggers replace default view modifications [OK]

Quick Trick: INSTEAD OF triggers replace default view modifications [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

In PostgreSQL, what is the primary function of an INSTEAD OF trigger defined on a view?