Re: [GENERAL] Help with restoring a dump in Tar format?(dependencies/ordering) - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Help with restoring a dump in Tar format?(dependencies/ordering)
Date
Msg-id d17fb96a-6ed2-fe96-1382-84c77b3ebbad@hogranch.com
Whole thread Raw
In response to Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
On 6/5/2017 5:15 PM, Ken Tanzer wrote:
> I can't really make this an FK.  I can (and probably will) put this
> into a trigger.  Although it seems like an extra layer of wrapping
> just to call a function.  I'm curious if there's any conceptual reason
> why constraints couldn't (as an option) be restored after all the data
> is loaded, and whether there would be any negative consequences of
> that?  I could see if your data still didn't pass the CHECKs, it's
> already loaded.  But the constraint could then be marked not valid?


when you have constraints that rely on calling functions, how would it
know what order to check things in ?


--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)