Re: pg_dump dumps row level policies on extension tables

2020-06-01 Thread Masahiko Sawada
On Tue, 19 May 2020 at 15:31, Pavan Deolasee wrote: > > Hi, > > I noticed that if a row level policy is defined on an extension > object, even in the extension creation script, pg_dump dumps a > separate CREATE POLICY statement for such policies. That makes the > dump unrestorable because the CREA

pg_dump dumps row level policies on extension tables

2020-05-18 Thread Pavan Deolasee
Hi, I noticed that if a row level policy is defined on an extension object, even in the extension creation script, pg_dump dumps a separate CREATE POLICY statement for such policies. That makes the dump unrestorable because the CREATE EXTENSION and CREATE POLICY then conflicts. Here is a simple e