Re: [HACKERS] pg_attribute.attisinherited ?

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"