Re: So maybe SQLERRM? Sb knows how to check it?

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Gorodowienko Daniel <daniel(dot)gorodowienko(at)interia(dot)pl>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: So maybe SQLERRM? Sb knows how to check it?
Date: 2005-06-08 18:50:48
Message-ID: 20050608185048.GC19344@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 08, 2005 at 08:03:40PM +0200, Gorodowienko Daniel wrote:
> Maybe I ask another way.
> In Oracle there is a variable SQLERRM, where error message is placed.
> How to get some message in PostgreSQL?
> I searched documentation 3 or 5 times, and Google, and wrote on forums
> topics and I have enough.

No, we don't have SQLERRM support yet. If you were asking about getting
the messages from RAISE EXCEPTION, I'm afraid there's no way to get it
in the EXCEPTION clause.

If you want to contribute it, patches are welcome ...

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message webmaster 2005-06-08 22:01:26 IMPORTANT NOTIFICATION
Previous Message Dan Black 2005-06-08 18:39:48 Re: Foreign keys and slow insert