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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: RAISE NOTICE
Следующее
От: Maximilian Tyrtania
Дата:
Сообщение: Re: Distinct oddity