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

Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns
Date: 2009-11-04 13:31:36
Message-ID: 20091104133136.GB3531@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
KaiGai Kohei wrote:

>   postgres=# SELECT * FROM t2;
>   ERROR:  could not find inherited attribute "b" of relation "t3"
> 
> Because t3.b is also inherited from the t2, but ALTER TABLE does not
> care about multiple inherited columns well.
> 
> I think we should not allow to rename a column with attinhcount > 1.

I think we should fix ALTER TABLE to cope with multiple inheritance.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-hackers by date

Next:From: Emmanuel CecchetDate: 2009-11-04 13:41:35
Subject: Re: DISTINCT ON
Previous:From: Heikki LinnakangasDate: 2009-11-04 12:53:34
Subject: Re: BUG #4961: pg_standby.exe crashes with no args

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