Re: Rows removed on child table when updating parent partitioned table.

2020-10-02 Thread Eduard Català
On Thu, Oct 1, 2020 at 8:02 PM David G. Johnston wrote: > The convention on these lists is to inline or bottom-post, please do not > top-post. > > On Thu, Oct 1, 2020 at 10:41 AM Jonathan Strong > wrote: > >> I've been away from coding for several years, but dusting off my chops >> and getting b

Rows removed on child table when updating parent partitioned table.

2020-10-01 Thread Eduard Català
Hi developers, We have a strange case where some rows are removed. I think it is a bug, but before notifying it I prefer to ask here where I am wrong. *Postgres 12* Given the following structure: create table parent ( id serial, constraint parent_pkey primary key (id)) partition by range (id); cr

pg_dump & RLS

2020-08-21 Thread Eduard Català
Hi all, Sorry if this is not the appropriate list, I think so. - ¿is posible to export using pg_dump only the rows that satisfy a rls check? - Of course, yes, use the --enable-row-security option in pg_dump - Yes, but my RLS expression relies on a GUC: CREATE POLICY my_policy ON my_table USING (