Re: Inherited tables and pg_dump - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Inherited tables and pg_dump
Date
Msg-id 1884.1022121201@sss.pgh.pa.us
Whole thread Raw
In response to Inherited tables and pg_dump  (Ingo van Lil <inguin@gmx.de>)
List pgsql-bugs
Ingo van Lil <inguin@gmx.de> writes:
> We've got a table that inherits another one, and we had to add a new
> column to the mother table (and thus to the son, too). Now, if we dump
> the database, the columns of the INSERT resp. COPY commands for the data
> of the son table are in wrong order.

Right at the moment you have to use pg_dump's -D option to deal with
this situation.  See discussion earlier today...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Ingo van Lil
Date:
Subject: Inherited tables and pg_dump
Next
From: Mark J Hewitt
Date:
Subject: JDBC driver changes for 1.4.0 JDK (pg 7.2.1)