OSDN Git Service

Tweak SPI_cursor_open to allow INSERT/UPDATE/DELETE RETURNING; this was
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Aug 2006 20:05:56 +0000 (20:05 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 Aug 2006 20:05:56 +0000 (20:05 +0000)
commit3f8db37c2f1eeeffd9dae3189b783a463f56fe77
treef6520123161af6191b5f53262d67eab69b24eccf
parent883f4b42d7292f1a7142e55046cee86f92049b5a
Tweak SPI_cursor_open to allow INSERT/UPDATE/DELETE RETURNING; this was
merely a matter of fixing the error check, since the underlying Portal
infrastructure already handles it.  This in turn allows these statements
to be used in some existing plpgsql and plperl contexts, such as a
plpgsql FOR loop.  Also, do some marginal code cleanup in places that
were being sloppy about distinguishing SELECT from SELECT INTO.
16 files changed:
doc/src/sgml/plperl.sgml
doc/src/sgml/plpgsql.sgml
doc/src/sgml/spi.sgml
src/backend/commands/portalcmds.c
src/backend/executor/execMain.c
src/backend/executor/functions.c
src/backend/executor/spi.c
src/backend/optimizer/prep/prepjointree.c
src/backend/optimizer/util/clauses.c
src/backend/parser/analyze.c
src/backend/parser/parse_clause.c
src/backend/parser/parse_expr.c
src/backend/rewrite/rewriteDefine.c
src/backend/tcop/utility.c
src/include/nodes/parsenodes.h
src/include/tcop/utility.h