Re: Best practice for loading data into relational tables
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 19 Mar 2008 15:00:10 -0700 (PDT)
Message-ID: <1fef4f37-38c7-4268-80b1-e47fc3d5cb24@d4g2000prg.googlegroups.com>
Date: Wed, 19 Mar 2008 15:00:10 -0700 (PDT)
Message-ID: <1fef4f37-38c7-4268-80b1-e47fc3d5cb24@d4g2000prg.googlegroups.com>
On 18 Marts, 22:14, DA Morgan <damor..._at_psoug.org> wrote:
> Gints Plivna wrote:
> > then you'd have to either disable a few FKses or make them deferred
> > and commit only at the very end of insert process when everything is
> > OK.
>
> Or use deferrable constraints which would likely be better than
> disabling default immediate constraints.
> --
Hmmm guess where is the difference? Yes - you got it right, there isnt! ;)
Gints Plivna
http://www.gplivna.eu
Received on Wed Mar 19 2008 - 17:00:10 CDT