Postgres Pro
Downloads
Home   >   mailing lists

Re: Substitute of TRY and CATCH in postgres - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: Substitute of TRY and CATCH in postgres
Date
Msg-id 0fde17f1-3d4c-451a-6746-52ec16d16155@gmx.net
Whole thread Raw
In response to Substitute of TRY and CATCH in postgres  (aditya desai <admad123@gmail.com>)
List pgsql-sql
Tree view 
aditya desai schrieb am 19.04.2021 um 15:21:
> We have a MSSQL proc which reads as below. We have to convert it to
> Postgres using TRY CATCH. I googled about it and could not find
> significant information. Can someone help?
You need an exception block:

https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

pgsql-sql by date:

Previous
From: aditya desai
Date:
Subject: Substitute of TRY and CATCH in postgres
Next
From: Rein Petersen
Date:
Subject: set Assert checking on by session