Re: Fix bug of CHECK constraint enforceability recursion - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: Fix bug of CHECK constraint enforceability recursion
Date
Msg-id CAN4CZFPkeF+=sk9KxxncuzGb-Q2NsMG4zoUgff-TiHeEdzwU+w@mail.gmail.com
Whole thread
Responses Re: Fix bug of CHECK constraint enforceability recursion
List pgsql-hackers
> * It is common for a partitioned table to have thousands of partitions, but I rarely hear of a regular inherited
tablehaving thousands of descendants.
 

Yes, that's why I also wasn't sure if it's needed or not, I can
construct scenarios where alters take a relatively long time, but
those do not seem to be realistic at all... so maybe it's an
acceptable limitation as you said.

> BTW, do you have any comments on the doc changes in 0002 and 0003?

+   (check and not-null constraints) down the inheritance hierarchy.  With
+   multiple inheritance, if a column or constraint is inherited from more
+   than one parent, the stricter definition applies.

The documentation changes generally look good to me, but should this
statement be part of the alter table description? There's a paragraph
about merge rules above which might be a better fit for it.
("Inheritable check constraints and not-null constraints are merged in
a similar fashion")



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] CI: Add a CPAN cache on Windows
Next
From: Baji Shaik
Date:
Subject: Re: [PATCH] Add regression tests for btree skip scan support functions