Skip site navigation (1) Skip section navigation (2)

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 05:28:37
Message-ID: 20030617052837.GB9181@metux.de (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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(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

Responses

pgsql-admin by date

Next:From: A.BhuvaneswaranDate: 2003-06-17 06:37:31
Subject: Re: Can the frontend get notifications from the postgres
Previous:From: Anagha JoshiDate: 2003-06-17 04:39:04
Subject: Can the frontend get notifications from the postgres server?

pgsql-sql by date

Next:From: A.BhuvaneswaranDate: 2003-06-17 06:37:31
Subject: Re: Can the frontend get notifications from the postgres
Previous:From: Tom LaneDate: 2003-06-17 04:42:54
Subject: Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group