Re: Problems with pg_restore

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with pg_restore
Дата
Msg-id 19996.1103561141@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with pg_restore  (Kaloyan Iliev Iliev <news1@faith.digsys.bg>)
Ответы Re: Problems with pg_restore
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: PG8 final when
Следующее
От: Kaloyan Iliev Iliev
Дата:
Сообщение: Re: Problems with pg_restore