notifying

Поиск
Список
Период
Сортировка
От Mirek Budzanowski
Тема notifying
Дата
Msg-id 199905271353.PAA07490@pogwizd.ii.uni.wroc.pl
обсуждение исходный текст
Ответы Re: [SQL] notifying  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Remigiusz Sokolowski
Дата:
Сообщение: Re: [SQL] about permissions
Следующее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [SQL] pgsql and shopping carts - is there any development cod e out there?