Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: majid(at)apsalar(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns
Date: 2014-03-13 13:47:39
Message-ID: 20140313134739.GD4744@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

majid(at)apsalar(dot)com wrote:

> Reproduction case:
>
> create table A(a int, b int, c int);
> create table B(a int, c int);
> alter table A inherit B;

I wonder if the real fix here is to have ALTER / INHERIT error out of
the columns in B are not a prefix of those in A.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marko Tiikkaja 2014-03-13 13:55:44 Re: BUG #9557: Row not visible after receiving notification
Previous Message Tom Lane 2014-03-13 13:47:37 Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-03-13 13:51:34 Re: gaussian distribution pgbench
Previous Message Tom Lane 2014-03-13 13:47:37 Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns