Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg_attribute.attisinherited ?

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] pg_attribute.attisinherited ?
Date: 2002-08-28 07:59:48
Message-ID: 20020828035948.7e65a4a8.alvherre@atentus.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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"

In response to

Responses

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 2002-08-28 08:05:21
Subject: Re: MemoryContextAlloc: invalid request size 1934906735
Previous:From: Christopher Kings-LynneDate: 2002-08-28 07:32:49
Subject: Re: [HACKERS] Proposed GUC Variable

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2002-08-28 08:41:27
Subject: Re: [HACKERS] pg_attribute.attisinherited ?
Previous:From: Christopher Kings-LynneDate: 2002-08-28 07:32:49
Subject: Re: [HACKERS] Proposed GUC Variable

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group