[Solved] What will be the output of this PostgreSQL block?DO $ BEGIN RAISE EXCEPTION 'Fatal error';... WHEN OTHERS THEN RAISE NOTICE 'General exception caught'; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

What will be the output of this PostgreSQL block?

DO $$
BEGIN
  RAISE EXCEPTION 'Fatal error';
EXCEPTION
  WHEN unique_violation THEN
    RAISE NOTICE 'Unique violation caught';
  WHEN OTHERS THEN
    RAISE NOTICE 'General exception caught';
END $$;

ANo output, block completes silently

BNOTICE: Unique violation caught

CFATAL: Fatal error

DNOTICE: General exception caught

Step-by-Step Solution

Solution:

Step 1: Analyze the raised exception
The block raises a generic exception with message 'Fatal error'.
Step 2: Check exception handlers
There is a handler for unique_violation and a catch-all handler WHEN OTHERS.
Step 3: Determine which handler runs
Since the exception is not a unique_violation, the WHEN OTHERS handler executes.
Final Answer:
NOTICE: General exception caught -> Option D
Quick Check:
WHEN OTHERS catches all exceptions not matched earlier [OK]

Quick Trick: WHEN OTHERS catches all unmatched exceptions [OK]

Common Mistakes:

Assuming unique_violation handler will run for all exceptions
Expecting the block to terminate without notice

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

What will be the output of this PostgreSQL block?

Step 1: Analyze the raised exception

Step 2: Check exception handlers

Step 3: Determine which handler runs

Final Answer:

Quick Check:

Want More Practice?