Re: Deferrable FK

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Thu, 29 Aug 2002 18:53:48 GMT
Message-ID: <05ub9.17478$w51.5270263@news2.news.adelphia.net>

Mike Burden <bmike_at_eidosnet.co.uk> wrote in message news:3d6bf41a$0$27141$afc38c87_at_news.eidosnet.co.uk...
> Thanks for the reply and very interesting.
>
> I suspect (and I'm guessing) the reason deferrable constraints
wasn't chosen
> initially was because deferrable constraints didn't exist.
>
> In the case of FK constraints it does beg the question - what type
of FK
> constraint or usage would make it not deferrable? It would seem
simpler to
> make all FK constraints deferrable and leave it up to the programmer
to
> decide which method they prefer.
>

Maybe you are trying to enforce business rules for a certain process flow?

I think this is more of a design issue than a programming issue. Programmers (including me) can suffer from tunnel vision (I need to do such and so to get my part done, ignoring the effects on the overall system.)

Ed Received on Thu Aug 29 2002 - 13:53:48 CDT