Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: imyfess(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row
Date: 2016-09-22 15:36:47
Message-ID: 24622.1474558607@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

imyfess(at)gmail(dot)com writes:
> SELECT FOR UPDATE returns 0 rows in scenario below. But if I just execute
> sql query from second transaction it always returns 1 row.

I've pushed a patch for this. Thanks for the report!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-09-22 19:24:51 Re: Segmentation fault with pg_restore
Previous Message Tony Wecker 2016-09-22 06:31:38 Re: pgdg94 conflicts with RHEL 6.8