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

2020-10-02 Thread David G. Johnston
On Fri, Oct 2, 2020 at 9:11 AM Eduard Català wrote: > If no one else gives an opinion I will open a bug for at least, force an > update of the documentation. > It's been seen and begun to be discussed over on -hackers [1]. [1]

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

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

2020-10-01 Thread Jonathan Strong
On Thu, Oct 1, 2020 at 2: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

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

2020-10-01 Thread David G. Johnston
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 back up to speed with PostgreSQL (love it!). So please forgive me > if

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

2020-10-01 Thread Jonathan Strong
I've been away from coding for several years, but dusting off my chops and getting back up to speed with PostgreSQL (love it!). So please forgive me if my early answers here come off as naive. But my understanding of this suggests that you shouldn't be using "update" on a serial field. I'm

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);