NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commit4f7a95b

committed

Apply RLS policies to partitioned tables.

The new partitioned table capability added a new relkind, namelyRELKIND_PARTITIONED_TABLE. Update fireRIRrules() to apply RLSpolicies 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

1 parent93b7d97 commit4f7a95bCopy full SHA for 4f7a95b

File tree

3 files changed

+572

-1

lines changed

src
- backend/rewrite
  - rewriteHandler.c
- test/regress
  - expected
    - rowsecurity.out
  - sql
    - rowsecurity.sql

3 files changed

+572

-1

lines changed

`‎src/backend/rewrite/rewriteHandler.c`

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1835,7 +1835,8 @@ fireRIRrules(Query parsetree, List activeRIRs, bool forUpdatePushedDown)`
`1835`	`1835`
`1836`	`1836`	`/* Only normal relations can have RLS policies */`
`1837`	`1837`	`if (rte->rtekind!=RTE_RELATION\|\|`
`1838`		`-rte->relkind!=RELKIND_RELATION)`
	`1838`	`+(rte->relkind!=RELKIND_RELATION&&`
	`1839`	`+rte->relkind!=RELKIND_PARTITIONED_TABLE))`
`1839`	`1840`	`continue;`
`1840`	`1841`
`1841`	`1842`	`rel=heap_open(rte->relid,NoLock);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit4f7a95b

File tree

3 files changed

3 files changed

`‎src/backend/rewrite/rewriteHandler.c`

0 commit comments