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.
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
Alvaro Herrera wrote:
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 ...
Actually, Pavel Stehule sent in a patch for this
On Thu, Jun 09, 2005 at 12:25:19PM +1000, Neil Conway wrote:
Alvaro Herrera wrote:
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
Alvaro Herrera wrote:
Huh, I meant a patch for getting the error message from RAISE EXCEPTION.
Does Pavel's patch address that too?
Yes.
(I just posted a revised patch to -patches, I'll apply it later tonight.)
-Neil
---(end of broadcast)---