pgsql: Remove partial and undocumented GRANT .. FOREIGN TABLE support.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove partial and undocumented GRANT .. FOREIGN TABLE support.
Date: 2011-04-25 20:41:19
Message-ID: E1QESat-0003CC-6X@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Remove partial and undocumented GRANT .. FOREIGN TABLE support.

Instead, foreign tables are treated just like views: permissions can
be granted using GRANT privilege ON [TABLE] foreign_table_name TO role,
and revoked similarly. GRANT/REVOKE .. FOREIGN TABLE is no longer
supported, just as we don't support GRANT/REVOKE .. VIEW. The set of
accepted permissions for foreign tables is now identical to the set for
regular tables, and views.

Per report from Thom Brown, and subsequent discussion.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/be90032e0d1cf473bdd99aee94218218f59f29f1

Modified Files
--------------
doc/src/sgml/ref/grant.sgml | 4 +-
src/backend/catalog/aclchk.c | 52 ----------------------------------------
src/backend/parser/gram.y | 8 ------
src/backend/utils/adt/acl.c | 4 ---
src/include/nodes/parsenodes.h | 1 -
src/include/utils/acl.h | 2 -
6 files changed, 2 insertions(+), 69 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2011-04-25 21:01:22 pgsql: Refactor broken CREATE TABLE IF NOT EXISTS support.
Previous Message Tom Lane 2011-04-25 20:22:41 pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64