Subject | Re: CHECK Constraints (was: Re: [firebird-support] Re: Checking periods don't overla |
---|---|
Author | Ann W. Harrison |
Post date | 2004-06-15T17:18:37Z |
Peter,
a benefit. And we ought to have a mechanism that works.
Regards,
Ann
> > At 06:39 AM 6/15/2004, johnsparrowuk wrote:I wrote
> > >According to the quote from Ann (peace be upon her, grin) she also
> > >believes check constraints should operate in the system transaction
> > Right. And they don't. And they should. And it won't beYou asked
> > trivial to make them work. Damn!
>Would it be easier to implement DEFERRED constraints?Maybe, but getting an error sooner rather than later is
a benefit. And we ought to have a mechanism that works.
Regards,
Ann