Horton

Teach RemoveRoleFromObjectPolicy() about partitioned tables.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: f356ec57444e42e53474ad5a029cdf6dca195069
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2017-06-14T07:43:40Z
Releases: 10.0 
Teach RemoveRoleFromObjectPolicy() about partitioned tables.

Table partitioning, introduced in commit f0e44751d7, added a new
relkind - RELKIND_PARTITIONED_TABLE. Update
RemoveRoleFromObjectPolicy() to handle it, otherwise DROP OWNED BY
will fail if the role has any RLS policies referring to partitioned
tables.

Dean Rasheed, reviewed by Amit Langote.

Discussion: https://postgr.es/m/CAEZATCUnNOKN8sLML9jUzxecALWpEXK3a3W7y0PgFR4%2Buhgc%3Dg%40mail.gmail.com

Files

PathChange+/−
src/backend/commands/policy.c modified +2 −1
src/test/regress/expected/rowsecurity.out modified +4 −0
src/test/regress/sql/rowsecurity.sql modified +5 −0

Discussion