From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Create a pg_shdepend entry for each role in TO clause of policie |
Date: | 2015-07-28 23:03:12 |
Message-ID: | E1ZKDtw-0008G6-9Z@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Create a pg_shdepend entry for each role in TO clause of policies.
CreatePolicy() and AlterPolicy() omit to create a pg_shdepend entry for
each role in the TO clause. Fix this by creating a new shared dependency
type called SHARED_DEPENDENCY_POLICY and assigning it to each role.
Reported by Noah Misch. Patch by me, reviewed by Alvaro Herrera.
Back-patch to 9.5 where RLS was introduced.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/f781a0f1d88411978c9df5f05cbb4f46aabe3d24
Modified Files
--------------
doc/src/sgml/catalogs.sgml | 10 ++++
src/backend/catalog/pg_shdepend.c | 2 +
src/backend/commands/policy.c | 87 ++++++++++++++++++++---------
src/include/catalog/dependency.h | 5 ++
src/test/regress/expected/rowsecurity.out | 55 ++++++++++++++++++
src/test/regress/sql/rowsecurity.sql | 44 +++++++++++++++
6 files changed, 177 insertions(+), 26 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2015-07-28 23:03:16 | pgsql: Create a pg_shdepend entry for each role in TO clause of policie |
Previous Message | Tom Lane | 2015-07-28 22:43:55 | pgsql: Update our documentation concerning where to create data directo |