Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group