Subject CHECK Constraints (was: Re: [firebird-support] Re: Checking periods don't overla
Author peter_jacobi.rm
Hi Ann, John, All,

"Ann W. Harrison" <aharrison@i...> wrote:
> At 06:39 AM 6/15/2004, johnsparrowuk wrote:
> >According to the quote from Ann (peace be upon her, grin) she also
> >believes check constraints should operate in the system transaction
> >(is my jargon right? Basically exhibit consistent behaviour with
> >indexes, yeah?)
>
> Right. And they don't. And they should. And it won't be
> trivial to make them work. Damn!

=>Ann
Would it be easier to implement DEFERRED constraints?

=>John
Would it be good enough to learn at failed COMMIT, that
an overlap occured?

Regards,
Peter Jacobi