Re: 8 and 8i default constraint behavior

On Tue, 8 May 2001, postbus_at_sybrandb.demon.nl wrote:

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

I see the need for deferrable constraints.

> The need for deferrable constraints by default is quite clear.

Its not clear why should it be the default? I don't think one goes around updating primary keys very often (I assume this is what's going on with the Scott famous case).

-- 
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.