Subject Re: [Firebird-Architect] Re: Nulls in CHECK Constraints
Author Martijn Tonies
> > 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
> then you will see errors that will drive you crazy: "when I was inserting
> 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
Upscene Productions
Database development questions? Check the forum!