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: 95498F2B-CE0F-44F2-A51B-26A00367098C@dsgi.us (view raw or flat)
Thread:
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.

Alex

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?
>
>               http://archives.postgresql.org


In response to

Responses

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-2014 The PostgreSQL Global Development Group