Re: A question about RAISE NOTICE - Mailing list pgsql-general

From Luigi N. Puleio
Subject Re: A question about RAISE NOTICE
Date
Msg-id 452703.95699.qm@web33508.mail.mud.yahoo.com
Whole thread Raw
In response to A question about RAISE NOTICE  ("Luigi N. Puleio" <npuleio@rocketmail.com>)
List pgsql-general
Since I'm executing this from a PgSQL function, can be SQLWarning eventually called from inside the function?....

and to use it let me guess I have to install something related to java like JRE 1.5.0?...

Thanks
Ciao, Luigi

--- On Thu, 5/7/09, Kris Jurka <books@ejurka.com> wrote:

From: Kris Jurka <books@ejurka.com>
Subject: Re: [GENERAL] A question about RAISE NOTICE
To: "Craig Ringer" <craig@postnewspapers.com.au>
Cc: "Luigi N. Puleio" <npuleio@rocketmail.com>, pgsql-general@postgresql.org
Date: Thursday, May 7, 2009, 11:51 PM



On Thu, 7 May 2009, Craig Ringer wrote:

> Most programs will not be aware of notice messages. Unlike error
> messages there's no provision for them in standard JDBC/ODBC/etc APIs,
> and you have to specifically ask the client driver for them. Unless your
> app is aware of PostgreSQL specifically, it won't be doing that.

The JDBC API has a SQLWarning that we map notice messages to and are understood by client tools.

http://java.sun.com/javase/6/docs/api/java/sql/SQLWarning.html

Kris Jurka

-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Mag Gam
Date:
Subject: Column oriented pgsql
Next
From: "Massa, Harald Armin"
Date:
Subject: Accessing pg_controldata information from SQL