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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns
Дата
Msg-id 20140313134739.GD4744@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns  (majid@apsalar.com)
Ответы Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
majid@apsalar.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: BUG #9557: Row not visible after receiving notification