Subject | Insert without referential constraints |
---|---|
Author | kimon_the_athenian2 |
Post date | 2004-03-15T08:40:57Z |
Hi!
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
also?
Or would the only option be dropping the constraints before inserts
and creating them again after?
Thank you!
Aivar
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
also?
Or would the only option be dropping the constraints before inserts
and creating them again after?
Thank you!
Aivar