From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Date: Tue, 17 Jun 2003 14:38:53 +0200
Message-ID: <20030617123853.GB1687@metux.de> (raw)
In-Reply-To: <Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
References: <20030617080102.GB1959@metux.de>
<Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: weigelt@metux.de, pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
In-Reply-To: <20030617123853.GB1687@metux.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox