On Wed, Nov 2, 2016 at 10:46 PM, Sounak Chakraborty <soun...@gmail.com> 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 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 the current design? > Because from a quick view it looks like the security subquery can also be > easily attached to the main query and passed for processing in foreign > database.
Yeah, I don't see why that couldn't be made to work. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers