Re: 8 and 8i default constraint behavior

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 8 May 2001 18:47:56 +0200
Message-ID: <tfg8ls327i33f6@beta-news.demon.nl>

"Galen Boyer" <galenboyer_at_yahoo.com> wrote in message news:uwv7s10mk.fsf_at_primix.com...
> On Tue, 8 May 2001, howardjr_at_www.com wrote:
>
> > deferrable makes far more sense.
>
> Do you say this because application code shouldn't need to know
> which order it needs to insert rows, only that it needs to insert
> to all tables?
> --
> Galen
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.

Assume the famous case of increasing deptno by 10 in scott.dept In this case the correct order is the problem.

The need for deferrable constraints by default is quite clear.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue May 08 2001 - 11:47:56 CDT