notifying - Mailing list pgsql-sql

From Mirek Budzanowski
Subject notifying
Date
Msg-id 199905271353.PAA07490@pogwizd.ii.uni.wroc.pl
Whole thread Raw
Responses Re: [SQL] notifying
List pgsql-sql
Hello,

I got 2 proceses running on 2 different computers. One is Solaris
2.5.1 (a), the other HP-UX 10.20 (b). Postgres 6.4.2 ruuning on HP-UX. 
My proceses communicate with each other using postgres. 
They just do 'listen id', and the other send 'notify id' 
when is some data for the first. 
Both proceses wait on select() for notifies from the other.
But after some time waiting on select() when i do from psql
'select * from pg_listener;' I get some strage result!
Some times I get nothing, and some times only one proces!!
Am I doing something wrong, or notifying is broken, or I did not 
some documentation??? 
In my opinion, when I open connection to postmaster, 
I send only one 'listen id' command, and until I disconnect, or
do 'unlisten id' I sould receive notifies?

Mirek


--
Mirek Budzanowski; P.O. box 1739; 51-161 Wroclaw 8; Poland
Tel. +48 602 306674     http://www.tcs.uni.wroc.pl/~mirekb



pgsql-sql by date:

Previous
From: Remigiusz Sokolowski
Date:
Subject: Re: [SQL] about permissions
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] pgsql and shopping carts - is there any development cod e out there?