Skip site navigation (1) Skip section navigation (2)


From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: UNLISTEN bug
Date: 2010-09-22 17:04:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Jeff Davis wrote:
> In honor of the very first bug report I sent to postgresql more than 10
> years ago regarding UNLISTEN[1], I have decided to submit another
> UNLISTEN bug (against HEAD):
> Session1:
>    LISTEN foo;
>    BEGIN;
>    UNLISTEN foo;
> Session2:
>    NOTIFY foo;
> Session1:
>    SELECT 1;
>    COMMIT;
>    SELECT 1;
> I seem to recall testing out similar situations during my review of this
> patch, but I think the code has changed since that time.

So the problem report is?  I tested it and the problem is that the final
SELECT 1 hung.  Is that the problem?

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + It's impossible for everything to be true. +

In response to


pgsql-bugs by date

Next:From: Bruce MomjianDate: 2010-09-22 17:06:35
Subject: Re: UNLISTEN bug
Previous:From: Tom LaneDate: 2010-09-22 17:03:06
Subject: Re: BUG #5669: server process was terminated by exception 0xC0000005

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group