policies and extensions - Mailing list pgsql-general

From Marc Munro
Subject policies and extensions
Date
Msg-id 1581979568.18009.18.camel@bloodnok.com
Whole thread Raw
Responses Re: policies and extensions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: policies and extensions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Jean-Marc Lessard
Date:
Subject: pgstattuple extension - Can pgstattuple_approx support toast tables?
Next
From: Adrian Klaver
Date:
Subject: Re: policies and extensions