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)
commitbc116b3ab8c3e865235e6037163768687acc1335
tree260b715174cc86aaf4f819fc0e179f6bb9e7c8d6
parent539c0a35094d6f0091e612dcc85a302a5b3fd76b
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