Re: ADD/DROP INHERITS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ADD/DROP INHERITS
Дата
Msg-id 632.1149797038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ADD/DROP INHERITS  (Greg Stark <gsstark@mit.edu>)
Ответы Re: ADD/DROP INHERITS  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> It'll affect the order in which pg_dump lists the parents, which will
>> affect the order in which the columns are created on dump and reload.

> Hm, if column order is important for table with multiple parents then you have
> other problems already. The attislocal->1 mutation will cause any
> singly-inherited columns to go to the head of the list.

So?  They'll get re-merged with the parent column during CREATE TABLE
anyway.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: PG 8.2
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: How to avoid transaction ID wrap