Hi,
Is there an easy way to delete data in the presence of circular
foreign key constraints?
That is, how do you delete items from two or more tables at once so
that these constraints are not violated?
Amir
--
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail
Williamson, Nick wrote:
Hi all,
I see that in Derby, foreign key constraints don't support the deferred
/ deferrable syntax that I'm used to using in Oracle, and - creating
data in IJ by running a script - validation seems to take place straight
away by default (in other words, Der
Hi all,
I see that in Derby, foreign key constraints don't support the deferred
/ deferrable syntax that I'm used to using in Oracle, and - creating
data in IJ by running a script - validation seems to take place straight
away by default (in other words, Derby doesn't wait until t
> -Original Message-
> From: Daniel Morton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 8:24 AM
> To: Derby Discussion; [EMAIL PROTECTED]
> Subject: RE: Disabling foreign key constraints
>
> IMO, this feature would be quite beneficial, as it is
&
;
> P.S. MySQL is a db that "we" should not emulate when
> looking at features.
> (Yes I *am* an Informix bigot, but I also tolerate
> some others. ;-)
>
> > -Original Message-
> > From: Robert Enyedi
> [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday,
-
> From: Robert Enyedi [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 7:14 AM
> To: Derby Discussion
> Subject: Disabling foreign key constraints
>
> Is there a way in Derby to disable foreign key constraints?
>
> This should be something similar to the SET FOR
Is there a way in Derby to disable foreign key constraints?
This should be something similar to the SET FOREIGN_KEY_CHECKS = 0
statement in MySQL which, when set, makes the engine to ignore any
foreign key constraints.
I know that having the database constraints is the way to go, but for