Subject | Re: Firebird 1.5 RC5 Check Constraints on Domains |
---|---|
Author | kumasoftllc |
Post date | 2003-08-21T00:42:13Z |
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 firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:
definately resurfaced...domain checks are occurring before "before
insert" triggers.
--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:
> --- In firebird-support@yahoogroups.com, "kumasoftllc"to
> <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 theno
> > 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.