| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Paolo Saudin *EXTERN*" <paolo(at)ecometer(dot)it>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Get the exeption error description |
| Date: | 2007-05-24 08:15:41 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB202E4C79F@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-05-24 08:20:55 | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
| Previous Message | Purusothaman A | 2007-05-24 07:35:27 | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-05-24 08:20:55 | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
| Previous Message | Jasbinder Singh Bali | 2007-05-24 08:06:15 | why postgresql over other RDBMS |