[Solved] A trigger function causes an infinite loop when updating a row. What is a likely cause? — Ans: The trigger updates the same table without disabling itself | PostgreSQL

PostgreSQL - Triggers in PostgreSQL

A trigger function causes an infinite loop when updating a row. What is a likely cause?

AThe trigger function is written in the wrong language

BThe trigger updates the same table without disabling itself

CThe table has no primary key

DThe trigger is set to run AFTER DELETE

Step-by-Step Solution

Solution:

Step 1: Understand trigger recursion
If a trigger updates the same table it listens to without precautions, it can cause itself to run repeatedly.
Step 2: Evaluate options
The trigger updates the same table without disabling itself describes this common cause. Other options do not explain infinite loops.
Final Answer:
The trigger updates the same table without disabling itself -> Option B
Quick Check:
Trigger recursion causes infinite loops [OK]

Quick Trick: Avoid triggers updating same table without control [OK]

Common Mistakes:

Master "Triggers in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

A trigger function causes an infinite loop when updating a row. What is a likely cause?