pgsql: Remove partial and undocumented GRANT .. FOREIGN TABLE support. - Mailing list pgsql-committers

From Robert Haas
Subject pgsql: Remove partial and undocumented GRANT .. FOREIGN TABLE support.
Date
Msg-id E1QESat-0003CC-6X@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64
Next
From: Robert Haas
Date:
Subject: pgsql: Refactor broken CREATE TABLE IF NOT EXISTS support.