Re: BUG #5198: Plain dump: wrong field order for inherited tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5198: Plain dump: wrong field order for inherited tables
Date
Msg-id 14573.1258643619@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5198: Plain dump: wrong field order for inherited tables  ("Lyamin Mikhail" <lma032@gmail.com>)
List 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 by date:

Previous
From: Thomas Poindessous
Date:
Subject: Re: BUG #5196: Excessive memory consumption when using csvlog
Next
From: Valaki Valahol
Date:
Subject: Stored procedure error