projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5e77769) | patch
The previous fix in CVS HEAD and 8.4 for handling the case where a cursor
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 5 Jul 2010 09:27:57 +0000 (09:27 +0000)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 5 Jul 2010 09:27:57 +0000 (09:27 +0000)
commit97f29c865f4332d48465735b22a42d9b0deacd12
treef9ba1948ac1c0490787ddad03ba7212f9fc99ddatree | snapshot
parent5e7776941370491b17755de7472a81631fcfaeaecommit | diff
The previous fix in CVS HEAD and 8.4 for handling the case where a cursor
being used in a PL/pgSQL FOR loop is closed was inadequate, as Tom Lane
pointed out. The bug affects FOR statement variants too, because you can
close an implicitly created cursor too by guessing the "<unnamed portal X>"
name created for it.

To fix that, "pin" the portal to prevent it from being dropped while it's
being used in a PL/pgSQL FOR loop. Backpatch all the way to 7.4 which is
the oldest supported version.
src/backend/utils/mmgr/portalmem.c diff | blob | history
src/include/utils/portal.h diff | blob | history
src/pl/plpgsql/src/pl_exec.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.