Re: Problems with pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with pg_restore
Date: 2004-12-20 16:45:41
Message-ID: 19996.1103561141@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kaloyan Iliev Iliev 2004-12-20 17:01:49 Re: Problems with pg_restore
Previous Message Ian Barwick 2004-12-20 16:09:04 Re: PG8 final when