Subject | check constraint stops working after backup and restore |
---|---|
Author | Tomas Michalik |
Post date | 2002-09-11T13:10:35Z |
Hi,
my problem is:
I create a domain with check constraint.
e.g.
ALTER DOMAIN D_TRANSPORT_TYPE_ID
ADD CHECK (exists
(
select *
from transport_types
where tt_id = value
))
This constraint works OK. After backup and restore it stops working. It
objects even if the data is OK. Problem goes away after recompilation of
the constraint.
Is this known problem ?
We use FB 1 SS on Linux.
Regards,
Tom
=================================
Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic
e-mail: michalik@...
tel: +420 2 67283446
my problem is:
I create a domain with check constraint.
e.g.
ALTER DOMAIN D_TRANSPORT_TYPE_ID
ADD CHECK (exists
(
select *
from transport_types
where tt_id = value
))
This constraint works OK. After backup and restore it stops working. It
objects even if the data is OK. Problem goes away after recompilation of
the constraint.
Is this known problem ?
We use FB 1 SS on Linux.
Regards,
Tom
=================================
Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic
e-mail: michalik@...
tel: +420 2 67283446