I tried to define a policy within an extension but the policy does not
seem to belong to the extension. Is this the way it is supposed to be?
This is postgres 9.5.21
Here is the relevant code from the extension:
create table rls2 (
username text not null,
details text not null
);
create policy only_owner on rls2
for all
to session_user
using (username = user);
The table, as expected, depends on the extension but the policy does
not (determined by querying pg_depend).
Am I missing something special about policies or is this an oversight?
__
Marc