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


Reply via email to