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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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