On Fri, 2005-07-15 at 11:10 +0300, Hannu Krosing wrote:
> Bruce: could you change this TODO item
>
> o Prevent child tables from altering constraints like CHECK that were
> inherited from the parent table
>
> to
>
> o Prevent new child tables from inheriting constraints defined on
> parents with keyword ONLY:
> alter table ONLY t add constraint c check(x=y);
> Prevent child tables from altering constraints that were
> inherited from the parent table (i.e were defined without
> ONLY/with ALL)
My thought was to introduce a new type of constraint, ABSTRACT.
This would not be inherited (it is not a check constraint). It would
allow a table to be declared "will never contain rows".
This fits better with the ideas and common understandings of
inheritance.
Best Regards, Simon Riggs
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
