Postgres Pro
Downloads
Home   >   mailing lists

Re: Race condition with notifications - Mailing list pgsql-general

From Tom Lane
Subject Re: Race condition with notifications
Date
Msg-id 13061.1209946003@sss.pgh.pa.us
Whole thread Raw
In response to Race condition with notifications  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: Race condition with notifications
List pgsql-general
Tree view 
Scott Ribe <scott_ribe@killerbytes.com> writes:
> Uhm, yeah? 2 changes committed, 1 notice sent, 1 change visible on receipt
> of notice.

Possibly you got bit by the recently-fixed LISTEN/NOTIFY race condition?
http://archives.postgresql.org/pgsql-bugs/2008-03/msg00094.php
IIRC this could only be a problem if your listener had only just started
listening, though.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Race condition with notifications
Next
From: "Scott Marlowe"
Date:
Subject: Re: COPY Performance