Re: RAISE NOTICE
От | Luigi N. Puleio |
---|---|
Тема | Re: RAISE NOTICE |
Дата | |
Msg-id | 301031.49174.qm@web33503.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | RAISE NOTICE ("Luigi N. Puleio" <npuleio@rocketmail.com>) |
Список | pgsql-sql |
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello Jasen,<br /><br />doyou know if PQsetNoticeProcessor() is appliable to ADOQuery->Post()?<br /><br />I mean if I have an event where there'sADOQuery->Post(), should I do something like:<br /><br />returnvalue = ADOQuery->Post();<br /><pre class="example">PQsetNoticeProcessor(ADOConnection,PQnoticeProcessor, returnvalue);<br /></pre>right?...<br /><br />--- On<b>Sun, 5/10/09, Jasen Betts <i><jasen@xnet.co.nz></i></b> wrote:<br /><blockquote style="border-left: 2px solidrgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br />From: Jasen Betts <jasen@xnet.co.nz><br />Subject:Re: [SQL] RAISE NOTICE<br />To: pgsql-sql@postgresql.org<br />Date: Sunday, May 10, 2009, 10:57 AM<br /><br /><divclass="plainMail">On 2009-05-08, Luigi N. Puleio <<a href="/mc/compose?to=npuleio@rocketmail.com" ymailto="mailto:npuleio@rocketmail.com">npuleio@rocketmail.com</a>>wrote:<br />><br />> --0-1541576050-1241773508=:80512<br/>> Content-Type: text/plain; charset=us-ascii<br />><br />> Hello everyone...<br/>><br />> I have a PL/PgSQL function where I use RAISE NOTICE but this kind of RAISE can't be shownon windows with a popup message like the EXCEPTION, indeed it goes to log messages list..<br />> So, is there anyway to show a popup message with a custom textmessage on it from a PL/PgSQL function?...<br /><br />postgres doesn't producepopups (your application does that)<br /><br />To get notification you need to call PQsetNoticeProcessor() to registera callback function.<br /><br />-- <br />Sent via pgsql-sql mailing list (<a href="/mc/compose?to=pgsql-sql@postgresql.org" ymailto="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br/>To make changes to your subscription:<br /><ahref="http://www.postgresql.org/mailpref/pgsql-sql" target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></div></blockquote></td></tr></table><br />
В списке pgsql-sql по дате отправления: