]> granicus.if.org Git - postgresql/commit
Modify UPDATE/DELETE WHERE CURRENT OF to use the FOR UPDATE infrastructure to
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 16 Nov 2008 17:34:28 +0000 (17:34 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 16 Nov 2008 17:34:28 +0000 (17:34 +0000)
commit18004101acb98d8fefe7dda1c9f010cceff83b6d
tree2c9436b642ca63f2b831ba4e3cfd16d34436e6a2
parent30f272a79b248fea1f25d63a3648d2660d370a69
Modify UPDATE/DELETE WHERE CURRENT OF to use the FOR UPDATE infrastructure to
locate the target row, if the cursor was declared with FOR UPDATE or FOR
SHARE.  This approach is more flexible and reliable than digging through the
plan tree; for instance it can cope with join cursors.  But we still provide
the old code for use with non-FOR-UPDATE cursors.  Per gripe from Robert Haas.
doc/src/sgml/plpgsql.sgml
doc/src/sgml/ref/declare.sgml
doc/src/sgml/ref/delete.sgml
doc/src/sgml/ref/update.sgml
src/backend/executor/execCurrent.c
src/backend/executor/execMain.c
src/include/nodes/execnodes.h
src/test/regress/expected/portals.out
src/test/regress/sql/portals.sql