Postgres Pro
Downloads
Home   >   mailing lists

Re: cursors FOR UPDATE don't return most recent row - Mailing list pgsql-hackers

From Tom Lane
Subject Re: cursors FOR UPDATE don't return most recent row
Date
Msg-id 4086.1327725333@sss.pgh.pa.us
Whole thread Raw
In response to cursors FOR UPDATE don't return most recent row  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: cursors FOR UPDATE don't return most recent row  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I expected the FETCH to return one row, with the latest data, i.e.
> (1, 3), but instead it's returning empty.

This is the same thing I was complaining about in the bug #6123 thread,
http://archives.postgresql.org/message-id/9698.1327266271@sss.pgh.pa.us

It looks a bit ticklish to fix.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temp file missing during large pgbench data set
Next
From: Noah Misch
Date:
Subject: Re: initdb and fsync