Re: [HACKERS] Row level security implementation in Foreign Table in Postgres

2016-11-08 Thread Stephen Frost
Tom, all, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Robert Haas writes: > > On Wed, Nov 2, 2016 at 10:46 PM, Sounak Chakraborty > > wrote: > >> But my doubt is why this feature is not enabled in case of Foreign Table. > >> (ALTER FOREIGN TABLE doesn't have a option of enabling Row Level Securit

Re: [HACKERS] Row level security implementation in Foreign Table in Postgres

2016-11-03 Thread Tom Lane
Robert Haas writes: > On Wed, Nov 2, 2016 at 10:46 PM, Sounak Chakraborty wrote: >> But my doubt is why this feature is not enabled in case of Foreign Table. >> (ALTER FOREIGN TABLE doesn't have a option of enabling Row Level Security). >> Is this is not implemented due to some limitations in th

Re: [HACKERS] Row level security implementation in Foreign Table in Postgres

2016-11-03 Thread Robert Haas
On Wed, Nov 2, 2016 at 10:46 PM, Sounak Chakraborty wrote: > Row level security feature implementation in Postgres is through policy and > the row security qualifier is attached as a subquery to the main query before > query planning. The RLS is implemented through ALTER TABLE STATEMENT. > But m

[HACKERS] Row level security implementation in Foreign Table in Postgres

2016-11-02 Thread Sounak Chakraborty
Row level security feature implementation in Postgres is through policy and the row security qualifier is attached as a subquery to the main query before query planning. The RLS is implemented through ALTER TABLE STATEMENT. But my doubt is why this feature is not enabled in case of Foreign Table