Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14328: SELECT FOR UPDATE doesn't return existing row
Date
Msg-id 24622.1474558607@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14328: SELECT FOR UPDATE doesn't return existing row  (imyfess@gmail.com)
List pgsql-bugs
Tree view 
imyfess@gmail.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

pgsql-bugs by date:

Previous
From: Tony Wecker
Date:
Subject: Re: pgdg94 conflicts with RHEL 6.8
Next
From: Tom Lane
Date:
Subject: Re: Segmentation fault with pg_restore