Subject | Re: [ib-support] Is there any UNIQUE limit? |
---|---|
Author | Nando Dessena |
Post date | 2002-07-03T20:12:53Z |
Raul,
Actually, uniqueness cannot be enforced with triggers in a multi-user
environment. Otherwise it can be.
Now that's what I call a disadvantage ;-P.
and on the character set for text fields, AFAIK.
Approx. 240 bytes in the questioner's case.
Ciao
--
____
_/\/ando
> > index in two or three (non unique) slices, and then enforce uniquenessThis sentence is almost as incomplete as mine. ;-)
> > by means of a trigger or two.
> > This has some disadvantages, too.
>
> In fact, the disadvantage is that the uniqueness can not be enforced with
> triggers !
Actually, uniqueness cannot be enforced with triggers in a multi-user
environment. Otherwise it can be.
Now that's what I call a disadvantage ;-P.
> IB has a stupid low (about 200-300 bytes - I don't know for sureIt depends on the number of segments, on the data type of each segment
> but is documented) limit for an index size.
and on the character set for text fields, AFAIK.
Approx. 240 bytes in the questioner's case.
Ciao
--
____
_/\/ando