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

From: weigelt(at)metux(dot)de
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can the frontend get notifications from the postgres server?
Date: 2003-06-17 12:38:53
Message-ID: 20030617123853.GB1687@metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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(at)metux(dot)de
cellphone: +49 174 7066481 smsgate: sms(dot)weigelt(at)metux(dot)de
---------------------------------------------------------------------
Diese Mail wurde mit UUCP versandt. http://www.metux.de/uucp/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brent Howard 2003-06-17 12:39:16 Starting postgres on Solaris
Previous Message A.Bhuvaneswaran 2003-06-17 12:27:32 Re: Can the frontend get notifications from the postgres

Browse pgsql-sql by date

  From Date Subject
Next Message weigelt 2003-06-17 12:40:28 Re: Can the frontend get notifications from the postgres server?
Previous Message A.Bhuvaneswaran 2003-06-17 12:27:32 Re: Can the frontend get notifications from the postgres