Re: create partition table caused server crashed with self-referencing foreign key

On Wed, 22 Apr 2020 at 23:50, Michael Paquier wrote: > > On Wed, Apr 22, 2020 at 10:21:21PM +1200, David Rowley wrote: > > I pushed a patch to remove the Assert. I didn't really feel a need to > > make any adjustments to the regression tests for this. The Assert was > > clearly out of place, it's

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, Apr 22, 2020 at 10:21:21PM +1200, David Rowley wrote: > I pushed a patch to remove the Assert. I didn't really feel a need to > make any adjustments to the regression tests for this. The Assert was > clearly out of place, it's hard to imagine that this could ever get > broken again. Still,

Re: create partition table caused server crashed with self-referencing foreign key

Thanks all for quick fix and push. Thanks & Regards, Rajkumar Raghuwanshi On Wed, Apr 22, 2020 at 4:14 PM Ahsan Hadi wrote: > > > On Wed, Apr 22, 2020 at 2:45 PM amul sul wrote: > >> >> >> On Wed, Apr 22, 2020 at 2:59 PM amul sul wrote: >> >>> >>> >>> On Wed, Apr 22, 2020 at 2:27 PM David Ro

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, Apr 22, 2020 at 2:45 PM amul sul wrote: > > > On Wed, Apr 22, 2020 at 2:59 PM amul sul wrote: > >> >> >> On Wed, Apr 22, 2020 at 2:27 PM David Rowley >> wrote: >> >>> On Wed, 22 Apr 2020 at 20:11, amul sul wrote: >>> > >>> > On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi < >>> ra

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, 22 Apr 2020 at 21:30, amul sul wrote: > > On Wed, Apr 22, 2020 at 2:27 PM David Rowley wrote: >> >> On Wed, 22 Apr 2020 at 20:11, amul sul wrote: >> > >> > On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi >> > wrote: >> >> #2 0x00acd16a in ExceptionalCondition (conditionNa

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, Apr 22, 2020 at 2:59 PM amul sul wrote: > > > On Wed, Apr 22, 2020 at 2:27 PM David Rowley wrote: > >> On Wed, 22 Apr 2020 at 20:11, amul sul wrote: >> > >> > On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi < >> rajkumar.raghuwan...@enterprisedb.com> wrote: >> >> #2 0x00ac

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, Apr 22, 2020 at 2:27 PM David Rowley wrote: > On Wed, 22 Apr 2020 at 20:11, amul sul wrote: > > > > On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi < > rajkumar.raghuwan...@enterprisedb.com> wrote: > >> #2 0x00acd16a in ExceptionalCondition (conditionName=0xc32310 > "numfks

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, 22 Apr 2020 at 20:11, amul sul wrote: > > On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi > wrote: >> #2 0x00acd16a in ExceptionalCondition (conditionName=0xc32310 >> "numfks == attmap->maplen", errorType=0xc2ea23 "FailedAssertion", >> fileName=0xc2f0bf "tablecmds.c", lin

Re: create partition table caused server crashed with self-referencing foreign key

On Wed, Apr 22, 2020 at 1:21 PM Rajkumar Raghuwanshi < rajkumar.raghuwan...@enterprisedb.com> wrote: > Hi, > > Getting a server crash while creating partition table which have > self-referencing foreign key > > postgres=# CREATE TABLE part1 (c1 int PRIMARY KEY, c2 int REFERENCES > part1) PARTITIO

create partition table caused server crashed with self-referencing foreign key

Hi, Getting a server crash while creating partition table which have self-referencing foreign key postgres=# CREATE TABLE part1 (c1 int PRIMARY KEY, c2 int REFERENCES part1) PARTITION BY LIST (c1); CREATE TABLE postgres=# CREATE TABLE part1_p1 PARTITION OF part1 FOR VALUES IN (1); server closed