pgsql: Add new catalog called pg_init_privs

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add new catalog called pg_init_privs
Date: 2016-04-07 01:45:51
Message-ID: E1anz15-0007ps-DD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Add new catalog called pg_init_privs

This new catalog holds the privileges which the system was
initialized with at initdb time, along with any permissions set
by extensions at CREATE EXTENSION time. This allows pg_dump
(and any other similar use-cases) to detect when the privileges
set on initdb-created or extension-created objects have been
changed from what they were set to at initdb/extension-creation
time and handle those changes appropriately.

Reviews by Alexander Korotkov, Jose Luis Tallon

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/6c268df1276e9dd73e4d2cc89cf8787e8f186bda

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 108 +++++++++++++++++++++
src/backend/catalog/Makefile | 2 +-
src/backend/catalog/aclchk.c | 149 +++++++++++++++++++++++++++++
src/backend/catalog/dependency.c | 46 ++++++++-
src/bin/initdb/initdb.c | 143 +++++++++++++++++++++++++++
src/include/catalog/indexing.h | 3 +
src/include/catalog/pg_init_privs.h | 101 +++++++++++++++++++
src/test/regress/expected/sanity_check.out | 1 +
8 files changed, 549 insertions(+), 4 deletions(-)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-04-07 01:58:50 Re: Move PinBuffer and UnpinBuffer to atomics
Previous Message David Rowley 2016-04-07 01:07:32 Re: Performance improvement for joins where outer side is unique

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2016-04-07 01:59:43 Re: pgsql: Use GRANT system to manage access to sensitive functions
Previous Message Magnus Hagander 2016-04-06 16:41:46 Re: pgsql: Implement backup API functions for non-exclusive backups