Skip site navigation (1) Skip section navigation (2)

Re: Upgrade time, dump+restore trouble.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrade time, dump+restore trouble.
Date: 2007-10-17 16:10:34
Message-ID: 7031.1192637434@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Jesper Krogh <jesper(at)krogh(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Jesper KroghDate: 2007-10-17 19:11:17
Subject: Re: Upgrade time, dump+restore trouble.
Previous:From: Jesper KroghDate: 2007-10-17 14:18:21
Subject: Upgrade time, dump+restore trouble.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group