X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id B723730F018
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 12:40:21 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 15646-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 09:40:11 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 67FC630F001
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 09:40:10 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5HCeAGV015662
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:40:10 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5HCcrRA014901
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:38:53 +0200
Date: Tue, 17 Jun 2003 14:38:53 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617123853.GB1687@metux.de>
References: <20030617080102.GB1959@metux.de>
	<Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
User-Agent: Mutt/1.3.27i
X-Message-Flag: Wenn dieser Text erscheint besteht enorme Virengefahr. Bitte
	verwenden Sie niemals Outlook oder Outlook Express.
X-Archive-Number: 200306/194
X-Sequence-Number: 9185

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/