From: | "Luigi N(dot) Puleio" <npuleio(at)rocketmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Kris Jurka <books(at)ejurka(dot)com> |
Subject: | Re: A question about RAISE NOTICE |
Date: | 2009-05-08 08:52:34 |
Message-ID: | 452703.95699.qm@web33508.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)ejurka(dot)com> wrote:
From: Kris Jurka <books(at)ejurka(dot)com>
Subject: Re: [GENERAL] A question about RAISE NOTICE
To: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>
Cc: "Luigi N. Puleio" <npuleio(at)rocketmail(dot)com>, pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2009-05-08 09:12:21 | Re: migrating from MSSQL |
Previous Message | Mag Gam | 2009-05-08 08:51:05 | Column oriented pgsql |