To: pgsql-sql@postgresql.org
Path: not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.sql
Subject: Re: RAISE NOTICE
Date: 11 May 2009 08:49:32 GMT
Organization: Dis (not Dat) Organisation
Lines: 44
Message-ID: <gu8oqs$via$1@reversiblemaps.ath.cx>
References: <301031.49174.qm@web33503.mail.mud.yahoo.com>
NNTP-Posting-Host: localhost
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
User-Agent: slrn/pre1.0.0-2 (Linux)

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.
>