PostgreSQL plpgsql try catch block equivalent

Question

I am using PostgreSQL 9.6.

I have a PROCEDURE in sql server. That makes use of a try catch block. It looks a little bit like the code below:

        BEGIN TRANSACTION
        BEGIN TRY
        --do stuff here
        COMMIT TRANSACTION
        END TRY
        BEGIN CATCH
        ROLLBACK TRANSACTION
        --do error stuff here
        END CATCH

Upon doing some research, It seems like postgres does not make use of try catch. Is there some way to handle this in postgres the same way sql server does?

It is BEGIN ... EXCEPTION ... END in PL/pgSQL. But you cannot commit in a function. — Laurenz Albe
No; every function runs inside a single transaction (of course several functions can run in te same transaction, but you cannot commit or rollback inside a function). PostgreSQL v11 changes that. — Laurenz Albe

n8. n8. · Accepted Answer · 2018-08-17T18:17:10

Callbacks can handle potential errors:

https://www.postgresql.org/docs/9.4/static/ecpg-errors.html

PostgreSQL plpgsql try catch block equivalent

1 Answers