Re: Fix bug of CHECK constraint enforceability recursion

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Fix bug of CHECK constraint enforceability recursion
Date: 2026-06-05 18:44:51
Message-ID: CAN4CZFPkeF+=sk9KxxncuzGb-Q2NsMG4zoUgff-TiHeEdzwU+w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> * It is common for a partitioned table to have thousands of partitions, but I rarely hear of a regular inherited table having 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")

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Baji Shaik 2026-06-05 18:45:49 Re: [PATCH] Add regression tests for btree skip scan support functions
Previous Message Andres Freund 2026-06-05 18:38:11 Re: [PATCH] CI: Add a CPAN cache on Windows