Received: from pogwizd.ii.uni.wroc.pl (pogwizd.ii.uni.wroc.pl [156.17.4.17]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA96138 for ; Thu, 27 May 1999 09:54:17 -0400 (EDT) (envelope-from mirekb@tcs.uni.wroc.pl) Received: from arwena (arwena [156.17.4.16]) by pogwizd.ii.uni.wroc.pl (8.9.1/8.9.1) with SMTP id PAA07490 for ; Thu, 27 May 1999 15:53:48 +0200 (MET DST) Message-Id: <199905271353.PAA07490@pogwizd.ii.uni.wroc.pl> Date: Thu, 27 May 1999 15:53:53 +0200 (MET DST) From: Mirek Budzanowski Reply-To: Mirek Budzanowski Subject: notifying To: pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: o2pOF2HH5njoe8VxGpFieA== X-Mailer: dtmail 1.2.1 CDE Version 1.2.1 SunOS 5.6 sun4u sparc 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