pgsql: Improve UPDATE/DELETE WHERE CURRENT OF so that they can be used

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve UPDATE/DELETE WHERE CURRENT OF so that they can be used
Date: 2007-06-11 22:22:42
Message-ID: 20070611222242.A92199FB980@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve UPDATE/DELETE WHERE CURRENT OF so that they can be used from plpgsql
with a plpgsql-defined cursor. The underlying mechanism for this is that the
main SQL engine will now take "WHERE CURRENT OF $n" where $n is a refcursor
parameter. Not sure if we should document that fact or consider it an
implementation detail. Per discussion with Pavel Stehule.

Modified Files:
--------------
pgsql/doc/src/sgml:
plpgsql.sgml (r1.111 -> r1.112)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml.diff?r1=1.111&r2=1.112)
pgsql/src/backend/executor:
execCurrent.c (r1.1 -> r1.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execCurrent.c.diff?r1=1.1&r2=1.2)
execQual.c (r1.219 -> r1.220)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execQual.c.diff?r1=1.219&r2=1.220)
nodeTidscan.c (r1.54 -> r1.55)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeTidscan.c.diff?r1=1.54&r2=1.55)
pgsql/src/backend/nodes:
copyfuncs.c (r1.378 -> r1.379)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.378&r2=1.379)
equalfuncs.c (r1.309 -> r1.310)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.309&r2=1.310)
outfuncs.c (r1.310 -> r1.311)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/outfuncs.c.diff?r1=1.310&r2=1.311)
readfuncs.c (r1.208 -> r1.209)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/readfuncs.c.diff?r1=1.208&r2=1.209)
pgsql/src/backend/parser:
gram.y (r2.592 -> r2.593)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.592&r2=2.593)
parse_expr.c (r1.219 -> r1.220)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_expr.c.diff?r1=1.219&r2=1.220)
pgsql/src/backend/utils/adt:
ruleutils.c (r1.260 -> r1.261)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c.diff?r1=1.260&r2=1.261)
pgsql/src/include/executor:
executor.h (r1.140 -> r1.141)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/executor.h.diff?r1=1.140&r2=1.141)
pgsql/src/include/nodes:
primnodes.h (r1.131 -> r1.132)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/primnodes.h.diff?r1=1.131&r2=1.132)

Browse pgsql-committers by date

  From Date Subject
Next Message User Pgunittest 2007-06-11 22:38:58 pgunittest - GeneratorParser: New Directory
Previous Message User Pgunittest 2007-06-11 22:13:49 pgunittest - pgUnitTest: