Horton

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

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: David Rowley <dgrowleyml@gmail.com>
Cc: amul sul <sulamul@gmail.com>, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2020-04-22T11:50:51Z
Lists: pgsql-hackers 
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, it seems to me that there could be a point in having a test for
partitioned tables with FKs referencing themselves.  We have such
tests for plain tables for example.
--
Michael

Commits

  1. Remove bogus Assert in foreign key cloning code