Subject Re: [firebird-support] Insert without referential constraints
Author Martijn Tonies

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

These constraints are called "deferred constraints", something which
Firebird doesn't (yet) support.

It also doesn't support turning constraints OFF.

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

That's the only way.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions