| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shelby Cain <alyandon(at)yahoo(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pl/pgsql exceptions |
| Date: | 2004-09-04 04:57:38 |
| Message-ID: | 6151.1094273858@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> Is there any way to retrieve the error code and error
> message text when an exception has been caught via
> "exception when others" in pl/pgsql?
Not yet. I'm open to suggestions though ...
> I'm looking
> essentially for the equivalent of Oracle's pl/sql
> sqlerrm and sqlcode variables.
We can't just copy those, since we aren't using SQLCODE error
numbers. I'm not sure how to map the error/detail/hint structure
into all this, either ... and does a plpgsql function want to see
localized message texts, or not?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Smith | 2004-09-04 05:36:51 | Re: postgres "on in the internet" |
| Previous Message | Wes Palmer | 2004-09-04 04:01:40 | Re: How to determine a database is intact? |