db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Questionable part in reference manual of CONSTRAINT clause
Date Wed, 10 Oct 2007 07:52:23 GMT
Tomohito Nakayama <tomonaka@basil.ocn.ne.jp> writes:

> What I'm not sure is next sentence in above.
> ==============
> If the update rule is NO ACTION, Derby checks the dependent tables for
> foreign key constraints */after/ all deletes* have been executed but
> /before/ triggers have been executed. If any row in a dependent table
> violates a foreign key constraint, the statement is rejected.
> ==============
>
> I'm not sure why is "after all deletes" for "update".
> I think this may be mistake ....

I agree. It doesn't make sense unless it reads "after all updates have
been executed".

Dag

Mime
View raw message