Re: [HACKERS] RLS policy not getting honer while pg_dump on declarative partition

2017-06-19 Thread Stephen Frost
Amit, * Amit Langote (langote_amit...@lab.ntt.co.jp) wrote: > On 2017/06/17 9:20, Stephen Frost wrote: > > I think we could certainly consider if this behavior is desirable in a > > system which includes partitioning instead of inheritance, > > Do we want CREATE POLICY foo ON parent creating the

Re: [HACKERS] RLS policy not getting honer while pg_dump on declarative partition

2017-06-19 Thread Amit Langote
On 2017/06/17 9:20, Stephen Frost wrote: > Greetings, > > * Rushabh Lathia (rushabh.lat...@gmail.com) wrote: >> While doing some testing I noticed that RLS policy not getting honer >> while pg_dump on declarative partition. >> >> I can understand that while doing SELECT on individual child >>

Re: [HACKERS] RLS policy not getting honer while pg_dump on declarative partition

2017-06-16 Thread Stephen Frost
Greetings, * Rushabh Lathia (rushabh.lat...@gmail.com) wrote: > While doing some testing I noticed that RLS policy not getting honer > while pg_dump on declarative partition. > > I can understand that while doing SELECT on individual child > table, policy of parent is not getting applied. But is

[HACKERS] RLS policy not getting honer while pg_dump on declarative partition

2017-06-16 Thread Rushabh Lathia
While doing some testing I noticed that RLS policy not getting honer while pg_dump on declarative partition. I can understand that while doing SELECT on individual child table, policy of parent is not getting applied. But is this desirable behaviour? I think for partitions, any policy on the root