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 EA55930EFDD
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 08:05:22 +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 68072-10
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 05:05:12 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 9D00630F061
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 05:05:11 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5H85AAQ027197
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 10:05:10 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5H812e4004476
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 10:01:02 +0200
Date: Tue, 17 Jun 2003 10:01:02 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617080102.GB1959@metux.de>
References: <20030617052837.GB9181@metux.de>
	<Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
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/189
X-Sequence-Number: 9180

On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:

<snip>
> LISTEN/NOTIFY is yet another SQL. We can write a rule on an event and let 
> it notify. On the other hand, we can have a while(1) process which keeps 
> listening for that notification ie.. event. Once the event is occured, the 
> listening process would be notified. The listening process can be any 
> postgresql client including the one written in C, perl, php, etc.
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 ?

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/