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
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: