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