Re: Upgrade time, dump+restore trouble. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Upgrade time, dump+restore trouble.
Date
Msg-id 7031.1192637434@sss.pgh.pa.us
Whole thread Raw
In response to Upgrade time, dump+restore trouble.  (Jesper Krogh <jesper@krogh.cc>)
Responses Re: Upgrade time, dump+restore trouble.  (Jesper Krogh <jesper@krogh.cc>)
List 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 by date:

Previous
From: Jesper Krogh
Date:
Subject: Upgrade time, dump+restore trouble.
Next
From: Jesper Krogh
Date:
Subject: Re: Upgrade time, dump+restore trouble.