Disallow scrolling of FOR UPDATE/FOR SHARE cursors, so as to avoid problems
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 24 Oct 2007 23:27:08 +0000 (23:27 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 24 Oct 2007 23:27:08 +0000 (23:27 +0000)
commit86271aac0b9a93a493d0175042a7406c19ebca97
treebee79d67b35202f53bc448dde2b74250a36ecc75
parent249db4826541cc09026e9dcb4adb8f2c6865418c
Disallow scrolling of FOR UPDATE/FOR SHARE cursors, so as to avoid problems
in corner cases such as re-fetching a just-deleted row.  We may be able to
relax this someday, but let's find out how many people really care before
we invest a lot of work in it.  Per report from Heikki and subsequent
discussion.

While in the neighborhood, make the combination of INSENSITIVE and FOR UPDATE
throw an error, since they are semantically incompatible.  (Up to now we've
accepted but just ignored the INSENSITIVE option of DECLARE CURSOR.)
doc/src/sgml/ref/declare.sgml
src/backend/commands/portalcmds.c
src/backend/executor/spi.c
src/backend/parser/analyze.c
src/include/nodes/parsenodes.h
src/test/regress/expected/portals.out
src/test/regress/sql/portals.sql