Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 570532E00F4 for ; Fri, 29 Feb 2008 03:44:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77712-04 for ; Fri, 29 Feb 2008 03:44:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id E22F42E00F7 for ; Fri, 29 Feb 2008 03:44:12 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Fri, 29 Feb 2008 08:44:10 +0100 Message-Id: <47C7C5D3.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Fri, 29 Feb 2008 08:44:03 +0100 From: "Bart Degryse" To: "Alex Hochberger" , "Tom Lane" Cc: Subject: Re: pl/pgsql and error handling References: <650E1D02-A244-44F4-81A4-5977F8D879E8@dsgi.us><22011.1204260185@ sss.pgh.pa.us><95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us> In-Reply-To: <95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part8CAA01D3.1__=" X-imss-version: 2.050 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/237 X-Sequence-Number: 30328 --=__Part8CAA01D3.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-= ERROR-TRAPPING would be the place to look. >>> Alex Hochberger 2008-02-29 6:29 >>> I do not know. It's sounds like the Oracle PL/SQL behavior is what I =20 want. Does PostgreSQL's pl/pgsql have such a feature? It's not in =20 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 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 =20 > 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 --=__Part8CAA01D3.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML 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?&nbs= p; 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?
>
> = ; &n= bsp; http://archives.postgresql= .org

---------------------------(end of broadcast)----------= -----------------
TIP 7: You can help support the PostgreSQL project by = donating at

&n= bsp; http://www.postgresql.org/about/donate
--=__Part8CAA01D3.1__=--