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 66C0F30F044
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 05:50:23 +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 64300-01
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 02:50:13 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 12A2B30F03C
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 02:50:12 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5H5oA7w016898
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 07:50:10 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5H5Sb8h012423
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 07:28:37 +0200
Date: Tue, 17 Jun 2003 07:28:37 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617052837.GB9181@metux.de>
References: <FF851C7EEB75954F9BCFB5CA117AB1EC61A41E@delta.nulinkinc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <FF851C7EEB75954F9BCFB5CA117AB1EC61A41E@delta.nulinkinc.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/187
X-Sequence-Number: 9178

On Tue, Jun 17, 2003 at 10:09:04AM +0530, Anagha Joshi wrote:
> 
(qestion in subject ...)

yes.
simply execute LISTEN <eventname>; on the one side and then 
an NOTIFY <eventname> on the other side. on the next query 
you'll see the notify. (you can easily try it w/ pgsql)

but i currently dont know, if you can receive notifies in php ... 
that's what i'm really interested in ...

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/