Skip site navigation (1) Skip section navigation (2)

Re: Inherited tables and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ingo van Lil <inguin(at)gmx(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Inherited tables and pg_dump
Date: 2002-05-23 02:33:21
Message-ID: 1884.1022121201@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Ingo van Lil <inguin(at)gmx(dot)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

In response to

pgsql-bugs by date

Next:From: Edwin GroothuisDate: 2002-05-23 04:43:15
Subject: Re: Bug #670: netmask displayed for a /32
Previous:From: Ingo van LilDate: 2002-05-22 23:48:54
Subject: Inherited tables and pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group