From: Bart Degryse <Bart.Degryse@indicator.be>
To: Alex Hochberger <alex@dsgi.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: pl/pgsql and error handling
Date: Fri, 29 Feb 2008 08:44:03 +0100
Message-ID: <47C7C5D3.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us>
References: <650E1D02-A244-44F4-81A4-5977F8D879E8@dsgi.us>
<22011.1204260185@ sss.pgh.pa.us>
<95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us>
www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING would be the place to look.
>>> Alex Hochberger <alex@dsgi.us> 2008-02-29 6:29 >>>
I do not know. It's sounds like the Oracle PL/SQL behavior is what I
want. Does PostgreSQL's pl/pgsql have such a feature? It's not in
the documentation anywhere. I'll check it from the office tomorrow.
Alex
On Feb 28, 2008, at 11:43 PM, Tom Lane wrote:
> Alex Hochberger <alex@dsgi.us> writes:
>> Is it possible to grab access to the actually user-friendly error
>> message?
>
> Doesn't the SQLERRM variable do what you want?
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org ( http://archives.postgresql.org/ )
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, alex@dsgi.us, tgl@sss.pgh.pa.us
Subject: Re: pl/pgsql and error handling
In-Reply-To: <47C7C5D3.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox