Re: Upgrade time, dump+restore trouble.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Upgrade time, dump+restore trouble.
Дата
Msg-id 7031.1192637434@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Upgrade time, dump+restore trouble.  (Jesper Krogh <jesper@krogh.cc>)
Ответы Re: Upgrade time, dump+restore trouble.  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-admin
Jesper Krogh <jesper@krogh.cc> writes:
> The tables are running a "home-made" timetravelling feature where a
> contraint on the table implements the foreing keys on the table.

You mean you have check constraints that do selects on other tables?
You have just found out (one reason) why that's a bad idea.

> How can I instruct pg_dumpall to turn off these constriants during
> dump/restore?

Drop the constraints in the source database.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jesper Krogh
Дата:
Сообщение: Upgrade time, dump+restore trouble.
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Upgrade time, dump+restore trouble.