Subject Re: Firebird 1.5 RC5 Check Constraints on Domains
Author kumasoftllc
I have a new DB created with FB 1.5 RC5 and the problem has
definately resurfaced...domain checks are occurring before "before
insert" triggers.

--- In, "Alexander V.Nevsky"
<ded@h...> wrote:
> --- In, "kumasoftllc"
> <kumasoftdev@b...> wrote:
> > Check constraints on Domains are being checked prior to "before
> > insert/update" triggers. This makes it impossible for triggers
> > perform validation and correct/default column values to meet the
> > requirements of the Domain. I could have sworn I read somewhere
> once
> > that this had been fixed in earlier versions of Firebird, but can
> > longer find such a statement. Can someone confirm the status of
> this
> > issue? Thanks.
> Yes, I can. It was fixed in FB long ago. But note if you have
> database created on very old FB version or on IB, you should
> re-compile triggers, backup/restore don't cure it.
> Best regards, Alexander.