> > Is it up to standard that enabling cross-table check constraints makes
> > it virtually impossible to strictly follow them?
>
> It's funny while you're inserting it.
> However, as a restore process proceeds, it may pump records in other

orders,

> then you will see errors that will drive you crazy: "when I was inserting

by

> hand, I didn't see any problem!" the user will say.

Isn't this why constraints should be created AFTER restoring the data? :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com