]> granicus.if.org Git - postgresql/commit
Create a pg_shdepend entry for each role in TO clause of policies.
authorJoe Conway <mail@joeconway.com>
Tue, 28 Jul 2015 23:01:53 +0000 (16:01 -0700)
committerJoe Conway <mail@joeconway.com>
Tue, 28 Jul 2015 23:01:53 +0000 (16:01 -0700)
commitf781a0f1d88411978c9df5f05cbb4f46aabe3d24
tree23fdbf53c265ac15dcc82d529b771ac11b2d42f0
parent8c72a7fab47a7f501d211468d6e477e1f3a20599
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.
doc/src/sgml/catalogs.sgml
src/backend/catalog/pg_shdepend.c
src/backend/commands/policy.c
src/include/catalog/dependency.h
src/test/regress/expected/rowsecurity.out
src/test/regress/sql/rowsecurity.sql