Re: Can the frontend get notifications from the postgres server?

Поиск
Список
Период
Сортировка
От weigelt@metux.de
Тема Re: Can the frontend get notifications from the postgres server?
Дата
Msg-id 20030617123853.GB1687@metux.de
обсуждение исходный текст
Ответ на Re: Can the frontend get notifications from the postgres  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-admin
On Tue, Jun 17, 2003 at 06:08:43AM -0600, scott.marlowe wrote:

<snip>
> > But the problem still is: how to receive the NOTIFY from an php script ?
> > which function of the c-client lib can be used for this ?
>
> If you're talking about a PHP script running under apache as a module or
> CGI, then you probably can't (or if you can, you shouldn't due to time out
> issues and such.)
No. The script is running as an standalone process (works as application server).
The Problem is, how to get the NOTIFY message, which is received from the
RDBMS somewhere in the client lib, to the php script.
When using psql, the NOTIFY is displayed after sending an query. It seems
that it is sent within the server's reply to the query. But i dont know
how the clientlib hands it to the application.

cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux ITS
 Webhosting ab 5 EUR/Monat.          UUCP, rawIP und vieles mehr.

 phone:     +49 36207 519931         www:       http://www.metux.de/
 fax:       +49 36207 519932         email:     contact@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Brent Howard"
Дата:
Сообщение: Starting postgres on Solaris
Следующее
От: weigelt@metux.de
Дата:
Сообщение: Re: Can the frontend get notifications from the postgres server?