Re: BETWEEN Node & DROP COLUMN - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: BETWEEN Node & DROP COLUMN
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEPNCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: BETWEEN Node & DROP COLUMN  (Alvaro Herrera <alvherre@atentus.com>)
Responses Re: BETWEEN Node & DROP COLUMN  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > Well, what happens if you rename a column in a child table?  
> Same problem?
> 
> It merrily renames the column in the child table (I tried it).  When
> SELECTing the parent, bogus data appears.  Looks like a bug to me.
> Maybe the ALTER TABLE ...  RENAME COLUMN code should check for inherited
> columns before renaming them.

Hmmm...so how does one check if one is a child in an inheritance hierarchy?

Chris





pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BETWEEN Node & DROP COLUMN
Next
From: Curt Sampson
Date:
Subject: Re: Should next release by 8.0 (Was: Re: [GENERAL] I am