Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 96D25633584
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 11 May 2009 03:02:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 71493-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 11 May 2009 03:02:12 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from web33503.mail.mud.yahoo.com (web33503.mail.mud.yahoo.com
	[68.142.206.152])
	by mail.postgresql.org (Postfix) with SMTP id 68C81632FAF
	for <pgsql-sql@postgresql.org>; Mon, 11 May 2009 03:02:10 -0300 (ADT)
Received: (qmail 50937 invoked by uid 60001); 11 May 2009 06:02:09 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rocketmail.com;
 s=s1024;
	t=1242021729; bh=qAjzPRbxPJrfFXldv9y/YCbakz7G9bXuOXI34zBdpHg=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type;
	b=jXwx2RNzxK751RHnVxzyWfxqWHKBPoKysYAxRuRu6rQkW//AbDfEtAdFOjQWHSPNFd3JsliLhjWMogRowpFNnlo9HiaXXEwrsmu6z+NL4HqAMYPz7v32ONloP8Yfl0a6iHdyIavZHBHr65XeeEawIg3Zhy8WNuZQAqt5KuC2/U8=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=rocketmail.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type;
	b=hpb/p+DozVito39Zo/6hUG6JIqMerHr3yiAW3LRIk4Mrh7ZnnwGfFr1m9jAR5O1IY5LxugCXIBiBiEH3NIrQ2sQbILPBTrN4FnQRm5uubOkp7z0TKRgnV7YhSykp9/sT5VB20d8R1T5I6fhRga1OlXM1x62ZKmjMjx4lH+TRcqI=;
Message-ID: <301031.49174.qm@web33503.mail.mud.yahoo.com>
X-YMail-OSG: 
 ShFEshMVM1n0rqIbUfM5GMxC0zAtlP5.AedBqzVP2VGhLS3L8hHHeu2RAh4GteJlHWi8N5oBaE6J87qEf9I_BdJ4XCZhmC5Y5POBP44fWSkJ9hmQR2AJW8qSJBpjM8CkR41vqvWZYO0MCTD7jQ4SMTEkB.KPvDdPK0QIyNx013OeKcG_EiPHdgOkPWpzP8NAhuTG5s1Hqgr9XNawNPS9sKr4.U8A1zMLD1RyDevp9Ffci9bkhxRaz_c2dzvtOKj8_.hiBJJ4Dqcrsyuus01CBwCzJLOkSQSaQeTDctu4x51D7nvPMRyffczxe7busiH5Mo6trc2VTbhlNlIIl6.OTC7QD68-
Received: from [82.52.50.214] by web33503.mail.mud.yahoo.com via HTTP;
	Sun, 10 May 2009 23:02:08 PDT
X-Mailer: YahooMailClassic/5.2.20 YahooMailWebService/0.7.289.10
Date: Sun, 10 May 2009 23:02:08 -0700 (PDT)
From: "Luigi N. Puleio" <npuleio@rocketmail.com>
Subject: Re: RAISE NOTICE
To: Jasen Betts <jasen@xnet.co.nz>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1686780820-1242021728=:49174"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200905/45
X-Sequence-Number: 32537


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

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



      
--0-1686780820-1242021728=:49174
Content-Type: text/html; charset=us-ascii

<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hello Jasen,<br><br>do you know if PQsetNoticeProcessor() is appliable to ADOQuery-&gt;Post()?<br><br>I mean if I have an event where there's ADOQuery-&gt;Post(), should I do something like:<br><br>returnvalue = ADOQuery-&gt;Post();<br><pre class="example">PQsetNoticeProcessor(ADOConnection, PQnoticeProcessor, returnvalue);<br></pre>right?...<br><br>--- On <b>Sun, 5/10/09, Jasen Betts <i>&lt;jasen@xnet.co.nz&gt;</i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Jasen Betts &lt;jasen@xnet.co.nz&gt;<br>Subject: Re: [SQL] RAISE NOTICE<br>To: pgsql-sql@postgresql.org<br>Date: Sunday, May 10, 2009, 10:57 AM<br><br><div class="plainMail">On 2009-05-08, Luigi N. Puleio &lt;<a ymailto="mailto:npuleio@rocketmail.com" href="/mc/compose?to=npuleio@rocketmail.com">npuleio@rocketmail.com</a>&gt;
 wrote:<br>&gt;<br>&gt; --0-1541576050-1241773508=:80512<br>&gt; Content-Type: text/plain; charset=us-ascii<br>&gt;<br>&gt; Hello everyone...<br>&gt;<br>&gt; 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..<br>&gt; So, is there any way to show a popup message with a custom textmessage on it from a PL/PgSQL function?...<br><br>postgres doesn't produce popups (your application does that)<br><br>To get notification you need to call PQsetNoticeProcessor() to register a callback function.<br><br>-- <br>Sent via pgsql-sql mailing list (<a ymailto="mailto:pgsql-sql@postgresql.org" href="/mc/compose?to=pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br>To make changes to your subscription:<br><a href="http://www.postgresql.org/mailpref/pgsql-sql"
 target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br></div></blockquote></td></tr></table><br>

      
--0-1686780820-1242021728=:49174--