Re: Get the exeption error description - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Get the exeption error description
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB202E4C79F@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to OIDs - file objects, are damaged by PostgreSQL.  ("Purusothaman A" <purusothaman.a@gmail.com>)
List pgsql-general
> Is there a way to know the error description / message in a
> BEGIN END block in a plpgsql functioin as in the 'Appendix A.
> PostgreSQL Error Codes' ?

The variable SQLERRM as described in

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

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Jasbinder Singh Bali"
Date:
Subject: why postgresql over other RDBMS
Next
From: Richard Huxton
Date:
Subject: Re: OIDs - file objects, are damaged by PostgreSQL.