Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6A5BA2E0181 for ; Fri, 29 Feb 2008 01:29:31 -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 48282-01-10 for ; Fri, 29 Feb 2008 01:29:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fmailhost01.isp.att.net (fmailhost01.isp.att.net [207.115.11.51]) by postgresql.org (Postfix) with ESMTP id 10BE02E01B2 for ; Fri, 29 Feb 2008 01:29:27 -0400 (AST) Received: from [192.168.100.100] (adsl-144-170-195.mia.bellsouth.net[72.144.170.195]) by isp.att.net (frfwmhc01) with SMTP id <20080229052926H0100mlu3de>; Fri, 29 Feb 2008 05:29:26 +0000 X-Originating-IP: [72.144.170.195] Cc: pgsql-sql@postgresql.org Message-Id: <95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us> From: Alex Hochberger To: Tom Lane In-Reply-To: <22011.1204260185@sss.pgh.pa.us> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: pl/pgsql and error handling Date: Fri, 29 Feb 2008 00:29:25 -0500 References: <650E1D02-A244-44F4-81A4-5977F8D879E8@dsgi.us> <22011.1204260185@sss.pgh.pa.us> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/236 X-Sequence-Number: 30327 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 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