Ensure that a cursor has an immutable snapshot throughout its lifespan.
The old coding was using a regular snapshot, referenced elsewhere, that was
subject to having its command counter updated. Fix by creating a private copy
of the snapshot exclusively for the cursor.
Backpatch to 8.4, which is when the bug was introduced during the snapshot
portalcmds.c (r1.79 -> r126.96.36.199)
spi.c (r1.208 -> r188.8.131.52)
snapmgr.c (r1.10 -> r184.108.40.206)
snapmgr.h (r1.5 -> r220.127.116.11)
portals.out (r1.21 -> r18.104.22.168)
portals.sql (r1.16 -> r22.214.171.124)
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2009-10-02 18:13:04|
|Subject: pgsql: Fix erroneous handling of shared dependencies (ie dependencies on |
|Previous:||From: Alvaro Herrera||Date: 2009-10-02 17:57:30|
|Subject: pgsql: Ensure that a cursor has an immutable snapshot throughout its |