Re: [HACKERS] pg_attribute.attisinherited ?

En Tue, 27 Aug 2002 17:26:56 -0400 (EDT)
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> escribió:

>
> Patch withdrawn by author.

Ok, new version. Please remember to change catversion.

Description of this patch:

- Adds a new attribute in pg_attribute named attisinherited.
- Creation of tables marks it true for attributes that are inherited
- Addition of new attribute to existing inherited table marks the
attribute as inherited for child tables.
- Checked when trying to rename inherited attributes: if table has
inheritors, only allow renaming if asked to recurse. Disallow
renaming for child tables only.
- Checked when trying to drop inherited attributes: if table has
inheritors, mark attribute as non-inherited for direct inheritors.
Disallow dropping for child tables only.

As an added bonus
- Check inheritance when adding new attributes (if table has inheritors,
only allow new attribute if it's inherited also).

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Acepta los honores y aplausos y perderas tu libertad"