From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: RAISE NOTICE
Date: 11 May 2009 08:49:32 GMT
Message-ID: <gu8oqs$via$1@reversiblemaps.ath.cx> (raw)
References: <301031.49174.qm@web33503.mail.mud.yahoo.com>
On 2009-05-11, Luigi N. Puleio <npuleio@rocketmail.com> wrote:
>
> --0-1686780820-1242021728=:49174
> Content-Type: text/plain; charset=us-ascii
>
> 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?...
I suspect that you'll need to get the PQ connection from ADO
and use that in the PQsetNoticeProcessor call. this may not be easy.
OTOH ADO may already do that if you can fogure out how to enable the
feature.
> --- On Sun, 5/10/09, Jasen Betts <jasen@xnet.co.nz> wrote:
>
> From: Jasen Betts <jasen@xnet.co.nz>
> Subject: Re: [SQL] RAISE NOTICE
> To: pgsql-sql@postgresql.org
> Date: Sunday, May 10, 2009, 10:57 AM
>
> On 2009-05-08, Luigi N. Puleio <npuleio@rocketmail.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.
>
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: jasen@xnet.co.nz
Subject: Re: RAISE NOTICE
In-Reply-To: <gu8oqs$via$1@reversiblemaps.ath.cx>
* 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