Re: BUG #5198: Plain dump: wrong field order for inherited tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5198: Plain dump: wrong field order for inherited tables
Дата
Msg-id 14573.1258643619@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5198: Plain dump: wrong field order for inherited tables  ("Lyamin Mikhail" <lma032@gmail.com>)
Список pgsql-bugs
"Lyamin Mikhail" <lma032@gmail.com> writes:
> 1) create table
> 2) create inherited table
> 3) add fields in parent table
> 4) add fields in child table
> 5) make dump

> Now you have wrong order of fields in insert.

AFAIK this will happen only if you use the --inserts switch, which is
deprecated for exactly this reason.  Let it use COPY as it will do
by default, or use --column-inserts if you must have insert statements.

If you think there's a problem without --inserts, you need to show an
exact example, not hand-waving.

            regards, tom lane

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

Предыдущее
От: Thomas Poindessous
Дата:
Сообщение: Re: BUG #5196: Excessive memory consumption when using csvlog
Следующее
От: Valaki Valahol
Дата:
Сообщение: Stored procedure error