Re: Problems with pg_restore - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with pg_restore
Date
Msg-id 19996.1103561141@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with pg_restore  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Responses Re: Problems with pg_restore  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
List pgsql-general
Kaloyan Iliev Iliev <news1@faith.digsys.bg> writes:
> You are right. I coleage of mine has added the delete column after the
> schema was created and it ptobably was on the bottom of the table and
> dumped there. But now when I restore the schema this column is on the
> top and the copy command wouldn't work. So I must change the schema file
> on hand. To remove the column from the tracking_base table, and to add
> it manuly on the bottem of each table that inherits it.

No, you need not change the database schema, just fix the COPY commands
for the child tables.

            regards, tom lane

pgsql-general by date:

Previous
From: Ian Barwick
Date:
Subject: Re: PG8 final when
Next
From: Kaloyan Iliev Iliev
Date:
Subject: Re: Problems with pg_restore