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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-sql by date

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