From: | "Luigi N(dot) Puleio" <npuleio(at)rocketmail(dot)com> |
---|---|
To: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: RAISE NOTICE |
Date: | 2009-05-11 06:02:08 |
Message-ID: | 301031.49174.qm@web33503.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello Jasen,
do you know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()?
I mean if I have an event where there's ADOQuery->Post(), should I do something like:
returnvalue = ADOQuery->Post();
PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue);
right?...
--- On Sun, 5/10/09, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:
From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Subject: Re: [SQL] RAISE NOTICE
To: pgsql-sql(at)postgresql(dot)org
Date: Sunday, May 10, 2009, 10:57 AM
On 2009-05-08, Luigi N. Puleio <npuleio(at)rocketmail(dot)com> wrote:
>
> --0-1541576050-1241773508=:80512
> Content-Type: text/plain; charset=us-ascii
>
> 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?...
postgres doesn't produce popups (your application does that)
To get notification you need to call PQsetNoticeProcessor() to register a callback function.
From | Date | Subject | |
---|---|---|---|
Next Message | Maximilian Tyrtania | 2009-05-11 06:28:45 | Re: Distinct oddity |
Previous Message | Jasen Betts | 2009-05-10 10:57:44 | Re: RAISE NOTICE |