Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the last sql error - Mailing list pgsql-novice

From Bartosz Dmytrak
Subject Re: Get the last sql error
Date
Msg-id CAD8_UcZ+O1qmUM8y6rNTvW74atfd=4ZNN+WqfZM04SW8gVDwUQ@mail.gmail.com
Whole thread Raw
In response to Get the last sql error  (Erik Ande <Erik.Ande@muthpartners.de>)
List pgsql-novice
Tree view

2013/6/5 Erik Ande <Erik.Ande@muthpartners.de>
@@error

Hi,
assuming:
1. definition: "Returns an error number if the previous statement encountered an error." by http://msdn.microsoft.com/en-us/library/ms188790.aspx
2. last (? - maybe first) error in current transaction
3. You use plpgsql


You can use GET STACKED DIAGNOSTICS (http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS). I think full BEGIN...EXCEPTION...END will do the work for you.

Regards,
Bartek

pgsql-novice by date:

Previous
From: Toni Alfirević
Date:
Subject: Re: DB design advice
Next
From: Sergey Konoplev
Date:
Subject: Re: DB design advice