From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: Luigi N. Puleio <npuleio@rocketmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: RAISE NOTICE
Date: Fri, 08 May 2009 10:40:17 -0300
Message-ID: <4A043641.7040700@fmed.uba.ar> (raw)
In-Reply-To: <599839.15720.qm@web33505.mail.mud.yahoo.com>
References: <599839.15720.qm@web33505.mail.mud.yahoo.com>
Luigi N. Puleio wrote:
> --- On Fri, 5/8/09, Gerardo Herzig <gherzig@fmed.uba.ar> wrote:
>
> From: Gerardo Herzig <gherzig@fmed.uba.ar>
> Subject: Re: [SQL] RAISE NOTICE
> To: "Luigi N. Puleio" <npuleio@rocketmail.com>
> Cc: pgsql-sql@postgresql.org
> Date: Friday, May 8, 2009, 11:34 AM
>
> Luigi N. Puleio wrote:
>> Hello everyone...
>>
>> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shown on windows with a popup message like the EXCEPTION, indeed it goes to log messages list..
>> So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?...
>>
>> Thanks to all in advance,
>> Ciao
>> Luigi
>>
>>
>>
>>
> That looks like a sql-client (pgAdmin, pgAccess,?) implementation
> feature, isnt?
>
> Gerardo
>
> Sort of....the message should come along a standalone application too
when with an ADO component I do a Post() which calls the function...just
the matter is I can't modify the application to manage a possibly
notification...only the postgresql's function...
> That's why I'm asking about a possibility to get a notification from
the function like it's an EXCEPTION...
>
Well, in that case, the ADO component is the client. This is the place
to modify de code, to capture the NOTICE. Im shure the ADO (or any other
component who actually connect to the database and makes the query) has
the ability to react when an EXCEPTION is thrown. My guess is that
EXCEPTION's goes trough StandardError, but NOTICE's goes trough
StandardOutput, and that could be some idea why your app is not getting
notice about NOTICES :)
I will wait for some expert dude to respond this, because im going
myself into unknown territory.
Gerardo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gherzig@fmed.uba.ar, npuleio@rocketmail.com
Subject: Re: RAISE NOTICE
In-Reply-To: <4A043641.7040700@fmed.uba.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox