Re: [HACKERS] pg_attribute.attisinherited ? - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [HACKERS] pg_attribute.attisinherited ?
Date
Msg-id 20020828035948.7e65a4a8.alvherre@atentus.com
Whole thread Raw
In response to Re: [HACKERS] pg_attribute.attisinherited ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] pg_attribute.attisinherited ?
Re: [HACKERS] pg_attribute.attisinherited ?
Re: [HACKERS] pg_attribute.attisinherited ?
List pgsql-patches
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"

pgsql-patches by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [HACKERS] Proposed GUC Variable
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] pg_attribute.attisinherited ?