From ajoshi@nulinkinc.com Tue Jun  17 04:39:25 2003
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 7C96A30F02B
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 04:39:25 +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 29425-10
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 01:39:15 -0300 (ADT)
Received: from TactiCom-MA1.TactiCom.com (unknown [216.235.244.20])
	by svr1.postgresql.org (Postfix) with SMTP id E4C3930EF76
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 01:39:14 -0300 (ADT)
Received: from [203.124.133.194] by TactiCom-MA1.Nulinkinc.com (NTMail
	4.30.0013/NU4135.00.d4f82e0c) with ESMTP id crjfiaaa for
	<pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 00:39:03 -0400
content-class: urn:content-classes:message
Subject: Can the frontend get notifications from the postgres server?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C3348A.61E58090"
Date: Tue, 17 Jun 2003 10:09:04 +0530
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Message-ID: <FF851C7EEB75954F9BCFB5CA117AB1EC61A41E@delta.nulinkinc.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Can the frontend get notifications from the postgres server?
Thread-Index: AcM0ig3xNJNDOKB8EdedngBABabtaA==
From: "Anagha Joshi" <ajoshi@nulinkinc.com>
To: <pgsql-admin@postgresql.org>
X-Spam-Status: No, hits=4.4 tagged_above=0.0 required=5.0 tests=HTML_60_70,
	RCVD_IN_DSBL
X-Spam-Level: ****
X-Archive-Number: 200306/186
X-Sequence-Number: 9177

This is a multi-part message in MIME format.

------_=_NextPart_001_01C3348A.61E58090
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



------_=_NextPart_001_01C3348A.61E58090
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.0.6249.1">
<TITLE>Can the frontend get notifications from the postgres server?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>

</BODY>
</HTML>
------_=_NextPart_001_01C3348A.61E58090--



From weigelt@metux.de Tue Jun  17 05:50:23 2003
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/



From bhuvan@symonds.net Tue Jun  17 06:40:48 2003
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 E4C6A30E6D9
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 06:40:48 +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 25996-08
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 03:40:38 -0300 (ADT)
Received: from Gateway.bksys.co.in (unknown [61.3.64.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 2A3C030DC8A
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 03:40:36 -0300 (ADT)
Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1])
	by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id h5H6eTB02664;
	Tue, 17 Jun 2003 12:10:30 +0530
Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71])
	by bksys.co.in (8.11.6/8.8.5) with ESMTP id h5H6eTX07007;
	Tue, 17 Jun 2003 12:10:29 +0530
Date: Tue, 17 Jun 2003 12:07:31 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvan@symonds.net>
X-X-Sender: bhuvan@Bhuvan.bksys.co.in
To: weigelt@metux.de
Cc: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres
In-Reply-To: <20030617052837.GB9181@metux.de>
Message-ID: <Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200306/188
X-Sequence-Number: 9179

> 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 weigelt@metux.de Tue Jun  17 08:05:22 2003
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 EA55930EFDD
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 08:05:22 +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 68072-10
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 05:05:12 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 9D00630F061
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 05:05:11 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5H85AAQ027197
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 10:05:10 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5H812e4004476
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 10:01:02 +0200
Date: Tue, 17 Jun 2003 10:01:02 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617080102.GB1959@metux.de>
References: <20030617052837.GB9181@metux.de>
	<Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
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/189
X-Sequence-Number: 9180

On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:

<snip>
> 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.
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 ?

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/



From scott.marlowe@ihs.com Tue Jun  17 12:11:05 2003
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 61B9330EFBF
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 12:11:05 +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 09290-08
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 09:10:55 -0300 (ADT)
Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222])
	by svr1.postgresql.org (Postfix) with ESMTP id 91FC630EFA8
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 09:10:54 -0300 (ADT)
Received: from css120.ihs.com (css120.ihs.com [170.207.105.120])
	by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h5HCA04w002029;
	Tue, 17 Jun 2003 06:10:00 -0600 (MDT)
Date: Tue, 17 Jun 2003 06:08:43 -0600 (MDT)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: <weigelt@metux.de>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: Can the frontend get notifications from the postgres
In-Reply-To: <20030617080102.GB1959@metux.de>
Message-ID: <Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-MailScanner: Found to be clean
X-MailScanner-SpamCheck: 
X-Archive-Number: 200306/190
X-Sequence-Number: 9181

On Tue, 17 Jun 2003 weigelt@metux.de wrote:

> On Tue, Jun 17, 2003 at 12:07:31PM +0530, A.Bhuvaneswaran wrote:
> 
> <snip>
> > 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.
> 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 probably can't (or if you can, you shouldn't due to time out 
issues and such.)

Note that PHP really is a "real programming language", and if you write a 
program to execute from the command line and detach it can run in the back 
ground like any other language, even starting child processes and having 
IPC and all that.  Look up the "Process Control Functions" for more on 
satrting child processes and all.

Note that the pcntl_* functions are not guaranteed to behave when run 
under apache / as a CGI etc...




From bhuvan@symonds.net Tue Jun  17 12:30:45 2003
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 D2C4B30EFB9
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 12:30:45 +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 11879-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 09:30:35 -0300 (ADT)
Received: from Gateway.bksys.co.in (unknown [61.3.64.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 2DBCD30EFB2
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 09:30:33 -0300 (ADT)
Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1])
	by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id h5HCUUB03660;
	Tue, 17 Jun 2003 18:00:31 +0530
Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71])
	by bksys.co.in (8.11.6/8.8.5) with ESMTP id h5HCUUX08639;
	Tue, 17 Jun 2003 18:00:30 +0530
Date: Tue, 17 Jun 2003 17:57:32 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvan@symonds.net>
X-X-Sender: bhuvan@Bhuvan.bksys.co.in
To: weigelt@metux.de
Cc: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres
In-Reply-To: <20030617080102.GB1959@metux.de>
Message-ID: <Pine.LNX.4.44.0306171744330.10221-100000@Bhuvan.bksys.co.in>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200306/192
X-Sequence-Number: 9183

> > 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.
> 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 ?

In perl, if i am correct, DBD::Pg does not support it. But, Pg - Perl5
extension for postgresql does it. The functions consumeInput() and
notifies can be used to access the notifyname and pid of backend process.
Refer the man page of Pg module for details.

In C, the functions PQconsumeInput() and PQnotifies can be used to access 
the notifyname and pid of backend process. Refer the libpq man page for 
details. 

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:

http://www.science.uva.nl/ict/documentation/php4/function.pg-get-notify.html

Hope it helps.

regards,
bhuvaneswaran




From weigelt@metux.de Tue Jun  17 12:40:21 2003
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 B723730F018
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 12:40:21 +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 15646-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 09:40:11 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 67FC630F001
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 09:40:10 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5HCeAGV015662
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:40:10 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5HCcrRA014901
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:38:53 +0200
Date: Tue, 17 Jun 2003 14:38:53 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617123853.GB1687@metux.de>
References: <20030617080102.GB1959@metux.de>
	<Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.33.0306170605270.1572-100000@css120.ihs.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/194
X-Sequence-Number: 9185

On Tue, Jun 17, 2003 at 06:08:43AM -0600, scott.marlowe wrote:

<snip>
> > 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 probably can't (or if you can, you shouldn't due to time out 
> issues and such.)
No. The script is running as an standalone process (works as application server).
The Problem is, how to get the NOTIFY message, which is received from the
RDBMS somewhere in the client lib, to the php script.
When using psql, the NOTIFY is displayed after sending an query. It seems
that it is sent within the server's reply to the query. But i dont know
how the clientlib hands it to the application.

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/



From weigelt@metux.de Tue Jun  17 12:45:38 2003
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 9A1C230F009
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 12:45:38 +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 18725-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 09:45:27 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id B3C3930F14D
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 09:45:25 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5HCjPHH015971
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:45:25 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5HCeS7j015180
	for pgsql-admin@postgresql.org; Tue, 17 Jun 2003 14:40:28 +0200
Date: Tue, 17 Jun 2003 14:40:28 +0200
From: weigelt@metux.de
To: pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Message-ID: <20030617124028.GC1687@metux.de>
References: <20030617080102.GB1959@metux.de>
	<Pine.LNX.4.44.0306171744330.10221-100000@Bhuvan.bksys.co.in>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.LNX.4.44.0306171744330.10221-100000@Bhuvan.bksys.co.in>
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/195
X-Sequence-Number: 9186

On Tue, Jun 17, 2003 at 05:57:32PM +0530, A.Bhuvaneswaran wrote:

<snip>
> 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
-- 
---------------------------------------------------------------------
 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/



From jgardner@jonathangardner.net Tue Jun  17 20:37:52 2003
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 8DD4030F24C
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 20:37:52 +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 83727-06
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 17:37:42 -0300 (ADT)
Received: from irko.smoothcorp.com (unknown [208.49.241.41])
	by svr1.postgresql.org (Postfix) with ESMTP id D2A4E30F22F
	for <pgsql-admin@postgresql.org>; Tue, 17 Jun 2003 17:37:41 -0300 (ADT)
Received: from jgardner.ifloor.com ([10.0.1.63])
	by irko.smoothcorp.com with esmtp (Exim 4.12)
	id 19SNCz-0000zo-00; Tue, 17 Jun 2003 13:37:37 -0700
Received: from jgardner.ifloor.com (localhost.localdomain [127.0.0.1])
	by jgardner.ifloor.com (8.12.8/8.12.8) with ESMTP id h5HKbdwr008564;
	Tue, 17 Jun 2003 13:37:39 -0700
Received: from localhost (localhost [[UNIX: localhost]])
	by jgardner.ifloor.com (8.12.8/8.12.8/Submit) id h5HKbcl8008562;
	Tue, 17 Jun 2003 13:37:38 -0700
From: Jonathan Gardner <jgardner@jonathangardner.net>
To: weigelt@metux.de, pgsql-admin@postgresql.org
Subject: Re: Can the frontend get notifications from the postgres server?
Date: Tue, 17 Jun 2003 13:37:37 -0700
User-Agent: KMail/1.5
References: <20030617052837.GB9181@metux.de>
	<Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
	<20030617080102.GB1959@metux.de>
In-Reply-To: <20030617080102.GB1959@metux.de>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Description: clearsigned data
Content-Disposition: inline
Message-Id: <200306171337.38334.jgardner@jonathangardner.net>
X-SA-Exim-Rcpt-To: weigelt@metux.de, pgsql-admin@postgresql.org
X-SA-Exim-Scanned: No; SAEximRunCond expanded to false
X-Archive-Number: 200306/208
X-Sequence-Number: 9199

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 17 June 2003 01:01, weigelt@metux.de 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 this ?
>

Why in the world would you want to? Think about this for a moment: The scri=
pt=20
runs in under a second - why would it want to sit around and wait for a=20
notification?

- --=20
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+73wRWgwF3QvpWNwRAistAJ4osnbDTKNQfg/0e83yR4SGq2eWSQCgy5iQ
8jx/eb09AFe4Kiy9WDhJa+k=3D
=3DvilQ
-----END PGP SIGNATURE-----



From weigelt@metux.de Tue Jun  17 23:35:25 2003
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 38C9B30F26E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 23:35:25 +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 08075-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jun 2003 20:35:14 -0300 (ADT)
Received: from annwfn.erfurt.igrz.de (annwfn.erfurt.igrz.de [195.190.142.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 724B630F2AD
	for <pgsql-sql@postgresql.org>; Tue, 17 Jun 2003 20:35:13 -0300 (ADT)
Received: from nibiru.UUCP (uucp@localhost)
	by annwfn.erfurt.igrz.de (8.12.9/8.12.9) with bsmtp id h5HNZDCn005010
	for pgsql-sql@postgresql.org; Wed, 18 Jun 2003 01:35:13 +0200
Received: (from weigelt@localhost)
	by metux.de (8.12.6/8.12.7) id h5HNY6Lg010809
	for pgsql-sql@postgresql.org; Wed, 18 Jun 2003 01:34:06 +0200
Date: Wed, 18 Jun 2003 01:34:06 +0200
From: weigelt@metux.de
To: PGSQL-SQL <pgsql-sql@postgresql.org>
Subject: Re: [ADMIN] Can the frontend get notifications from the postgres
	server?
Message-ID: <20030617233406.GA10722@metux.de>
References: <20030617052837.GB9181@metux.de>
	<Pine.LNX.4.44.0306171203020.10221-100000@Bhuvan.bksys.co.in>
	<20030617080102.GB1959@metux.de>
	<200306171337.38334.jgardner@jonathangardner.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200306171337.38334.jgardner@jonathangardner.net>
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/209
X-Sequence-Number: 13967

On Tue, Jun 17, 2003 at 01:37:37PM -0700, Jonathan Gardner wrote:

<snip>
> Why in the world would you want to? Think about this for a moment: 
> The script runs in under a second - why would it want to sit around 
> and wait for a notification?
No, my script runs hours, days, month ...

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/