|Subject||Re: [ib-support] check constraint stops working after backup and restore|
Tomas Michalik wrote:
>Not an answer to your question, but I'd use a foreign key constraint instead of a domain.
> my problem is:
> I create a domain with check constraint.
> ALTER DOMAIN D_TRANSPORT_TYPE_ID
> ADD CHECK (exists
> select *
> from transport_types
> where tt_id = value