From: Luigi N. Puleio <npuleio@rocketmail.com>
To: Jasen Betts <jasen@xnet.co.nz>
Cc: pgsql-sql@postgresql.org
Subject: Re: RAISE NOTICE
Date: Sun, 10 May 2009 23:02:08 -0700 (PDT)
Message-ID: <301031.49174.qm@web33503.mail.mud.yahoo.com> (raw)
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@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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
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: npuleio@rocketmail.com, jasen@xnet.co.nz
Subject: Re: RAISE NOTICE
In-Reply-To: <301031.49174.qm@web33503.mail.mud.yahoo.com>
* 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