Subject Re: [ib-support] check constraint stops working after backup and restore
Author Martijn Tonies

> > Domain shouldn't hold a database or table constraint - they should hold
> > value constraints only.
> Maybe. I haven't read anything like that anywhere. When I recompile the
> domain constraint, it works. Wouldn't it be better if it could work that
> way even after restore ? :-)

It's more of a conceptual thingy - domains can (should be able) to exists
without any tables/views in the database. What you're doing violates this.

Have a good look at the _conceptual_ meaning of a "domain" - you'll see
it has nothing to do with tables.

Personally, I think that a check constraint on a domain as you're having
should be rejected.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase

Firebird Workbench - the developer tool for Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."