Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-17 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 17 June 2003 01:01, [EMAIL PROTECTED] wrote: > On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote: > > 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

Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-17 Thread Brent Howard
On Tue, Jun 17, 2003 at 08:39:00 AM [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: |>> > 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 ? |>> |>> If you're talking about a PHP script running under apa

Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-17 Thread weigelt
On Tue, Jun 17, 2003 at 05:57:32PM +0530, A.Bhuvaneswaran wrote: > In php 4.3.0, the function pg_get_notify() can be used to access the > notifyname and pid of backend process. For details, please refer the below > link: aaah. that's what i needed :) cu -- --

Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-17 Thread weigelt
On Tue, Jun 17, 2003 at 06:08:43AM -0600, scott.marlowe wrote: > > 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 ? > > If you're talking about a PHP script running under apache as a module or > CGI, then you

Re: [ADMIN] Can the frontend get notifications from the postgres

2003-06-17 Thread A.Bhuvaneswaran
> > 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

Re: [ADMIN] Can the frontend get notifications from the postgres

2003-06-17 Thread scott.marlowe
On Tue, 17 Jun 2003 [EMAIL PROTECTED] wrote: > On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote: > > > > 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

Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-17 Thread weigelt
On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote: > 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 >

Re: [ADMIN] Can the frontend get notifications from the postgres

2003-06-16 Thread A.Bhuvaneswaran
> yes. > simply execute LISTEN ; on the one side and then > an NOTIFY 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 i

Re: [ADMIN] Can the frontend get notifications from the postgres server?

2003-06-16 Thread weigelt
On Tue, Jun 17, 2003 at 10:09:04AM +0530, Anagha Joshi wrote: > (qestion in subject ...) yes. simply execute LISTEN ; on the one side and then an NOTIFY 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 n