Subject Re: [firebird-support] Insert without referential constraints
Author Eddie Bush
Hi Aivar,

Perhaps you could emulate this on the client by caching the detail records until you're ready to create the master record - and then apply each in the proper order.

Good Luck!

----- Original Message -----
From: kimon_the_athenian2
Sent: Monday, March 15, 2004 2:40 AM
Subject: [firebird-support] Insert without referential constraints


Is it possible to insert a bunch of records related to each other via
foreign keys without worrying about the order of inserts?

I've heard that with some databases it's possible to set up a
transaction so that referential constraints are checked only at the
end of the transaction. Is something like this possible with Firebird

Or would the only option be dropping the constraints before inserts
and creating them again after?

Thank you!


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.620 / Virus Database: 399 - Release Date: 3/12/2004

[Non-text portions of this message have been removed]