Re: Help with restoring a dump in Tar format? (dependencies/ordering)

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with restoring a dump in Tar format? (dependencies/ordering)
Date: 2017-06-06 00:28:13
Message-ID: d17fb96a-6ed2-fe96-1382-84c77b3ebbad@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-06-06 00:32:53 Re: Help with restoring a dump in Tar format? (dependencies/ordering)
Previous Message Ken Tanzer 2017-06-06 00:15:50 Re: Help with restoring a dump in Tar format? (dependencies/ordering)