| From: | "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net> |
|---|---|
| To: | weigelt(at)metux(dot)de |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Can the frontend get notifications from the postgres |
| Date: | 2003-06-17 06:37:31 |
| Message-ID: | Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
> 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 ...
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.
regards,
bhuvaneswaran
| From | Date | Subject | |
|---|---|---|---|
| Next Message | weigelt | 2003-06-17 08:01:02 | Re: Can the frontend get notifications from the postgres server? |
| Previous Message | weigelt | 2003-06-17 05:28:37 | Re: Can the frontend get notifications from the postgres server? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-06-17 07:05:00 | Re: [HACKERS] Our FLOAT(p) precision does not conform to spec |
| Previous Message | weigelt | 2003-06-17 05:28:37 | Re: Can the frontend get notifications from the postgres server? |