Re: [ib-support] Re: check constraint stops working after backup and restore
----- Original Message -----
From: "Ian A. Newby" <ian@...>
Sent: Friday, September 13, 2002 11:32 AM
Subject: [ib-support] Re: check constraint stops working after backup and
> Hi All,
> > >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 ? :-)
> > How could it? Restore has to create the domains before it creates
> > tables, otherwise it couldn't create the tables.
> Although no currently possible, this could I believe be overcome
> with changes to the backup mechanism (and metadata extraction).
> Domains could be created without check constraints with the check
> constraints being added later, after the tables have been created.
But why - according to me :) -> it's wrong to have a check constraint
on a domain that involves tables...