Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Cause '*' and 'foo.*' notations to mark the referenced RTE(s) as - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Cause '*' and 'foo.*' notations to mark the referenced RTE(s) as
Date
Msg-id 20060814233932.A47539FB38F@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Cause '*' and 'foo.*' notations to mark the referenced RTE(s) as
requiring read permissions.  Up till now there was no possible case
in which the RTEs wouldn't already have ACL_SELECT set ... but now that
you can say something like 'INSERT INTO foo ... RETURNING *' this is
an essential step.  With this commit, a RETURNING clause adds the
requirement for SELECT permissions on the target table if and only if
the clause actually reads the value of at least one target-table column.

Modified Files:
--------------
    pgsql/src/backend/parser:
        parse_clause.c (r1.156 -> r1.157)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_clause.c.diff?r1=1.156&r2=1.157)
        parse_target.c (r1.147 -> r1.148)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_target.c.diff?r1=1.147&r2=1.148)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix oversight in initial implementation of PORTAL_ONE_RETURNING
Next
From: meskes@postgresql.org (Michael Meskes)
Date:
Subject: pgsql: Added lots of SoC stuff made by Joachim.