En Tue, 27 Aug 2002 17:26:56 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.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"