Horton

Apply RLS policies to partitioned tables.

Joe Conway <mail@joeconway.com>

View on postgr.es
Commit: 4f7a95be2c112bdc8da5f7e46cbb743b8ba4cc21
Author: Joe Conway <mail@joeconway.com>
Date: 2017-06-11T15:51:18Z
Releases: 10.0 
Apply RLS policies to partitioned tables.

The new partitioned table capability added a new relkind, namely
RELKIND_PARTITIONED_TABLE. Update fireRIRrules() to apply RLS
policies on RELKIND_PARTITIONED_TABLE as it does RELKIND_RELATION.

In addition, add RLS regression test coverage for partitioned tables.

Issue raised by Fakhroutdinov Evgenievich and patch by Mike Palmiotto.
Regression test editorializing by me.

Discussion: https://postgr.es/m/flat/20170601065959.1486.69906@wrigleys.postgresql.org

Files

PathChange+/−
src/backend/rewrite/rewriteHandler.c modified +2 −1
src/test/regress/expected/rowsecurity.out modified +428 −0
src/test/regress/sql/rowsecurity.sql modified +142 −0

Discussion

Cited messages not in the archive: flat/20170601065959.1486.69906@wrigleys.postgresql.org