Re: How do I capture the message from user defined function

From: "etsuko shimabukuro" <etsukos(at)meta-bit(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: How do I capture the message from user defined function
Date: 2003-02-03 07:09:53
Message-ID: PCEJINOPBBELPMMMEOJPOEPPCAAA.etsukos@meta-bit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Dear Kris,

Thank you for your email.
I tried this getWarnings(), but it didn't capture the "notice" level of the
messages.

Regards,
Etsuko

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Monday, February 03, 2003 15:59
To: etsuko shimabukuro
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] How do I capture the message from user defined function

On Mon, 3 Feb 2003, etsuko shimabukuro wrote:
>
> I'm trying to get a message which has been raised within my user-defined
> function.
> The message is created by using "raise notice". This message is not error
> so I'm using "notice" level.
>

Try using the getWarnings() method of the Connection object.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Łukasz Piątek 2003-02-03 07:16:04 Hierarchic database
Previous Message Kris Jurka 2003-02-03 06:58:47 Re: How do I capture the message from user defined function