Skip site navigation (1) Skip section navigation (2)

Re: pl/pgsql and error handling

From: Alex Hochberger <alex(at)dsgi(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pl/pgsql and error handling
Date: 2008-02-29 05:29:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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.


On Feb 28, 2008, at 11:43 PM, Tom Lane wrote:

> Alex Hochberger <alex(at)dsgi(dot)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?

In response to


pgsql-sql by date

Next:From: Bart DegryseDate: 2008-02-29 07:44:03
Subject: Re: pl/pgsql and error handling
Previous:From: Tom LaneDate: 2008-02-29 04:43:05
Subject: Re: pl/pgsql and error handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group