Ensure that a cursor is scanned under the same scanCommandId it was
Tom Lane <tgl@sss.pgh.pa.us>
Ensure that a cursor is scanned under the same scanCommandId it was originally created with, so that the set of visible tuples does not change as a result of other activity. This essentially makes PG cursors INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/command.c | modified | +16 −2 |
| src/backend/executor/spi.c | modified | +24 −7 |
| src/backend/utils/mmgr/portalmem.c | modified | +3 −1 |
| src/include/utils/portal.h | modified | +5 −3 |