Re: Race condition with notifications

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Race condition with notifications
Date: 2008-05-05 00:06:43
Message-ID: 13061.1209946003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Ribe <scott_ribe(at)killerbytes(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-05-05 00:11:15 Re: COPY Performance
Previous Message Scott Ribe 2008-05-04 23:55:28 Race condition with notifications