Re: Can the frontend get notifications from the postgres server? - Mailing list pgsql-admin

From weigelt@metux.de
Subject Re: Can the frontend get notifications from the postgres server?
Date
Msg-id 20030617123853.GB1687@metux.de
Whole thread Raw
In response to Re: Can the frontend get notifications from the postgres  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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 by date:

Previous
From: "Brent Howard"
Date:
Subject: Starting postgres on Solaris
Next
From: weigelt@metux.de
Date:
Subject: Re: Can the frontend get notifications from the postgres server?