Laurenz Albe <[email protected]> writes: > It may well be that somebody deleted or updated a few rows between the time > the cursor was materialized and the time the 50000th row was fetched.
Even without HOLD, a cursor will return a view of the data as it stood
when the cursor was opened, just as a plain SELECT does. There is
*plenty* of time for another session to get in there if you've been
groveling through 50K records one at a time.
regards, tom lane
