Subject | Re: [ib-support] Is there any UNIQUE limit? |
---|---|
Author | Nando Dessena |
Post date | 2002-07-02T11:24:22Z |
Matteo,
contraint is implemented by means of an underlying index, which has a
maximum "key size" of approx. 240 bytes.
To work around your problem, short of waiting for a future release of
Firebird, I don't see much you can do. Perhaps you could split your
index in two or three (non unique) slices, and then enforce uniqueness
by means of a trigger or two.
This has some disadvantages, too.
Ciao
--
____
_/\/ando
> Is there any kind of limit in the size of the fields of a CONSTRAINTnot exactly, but there is one on the size of an index. A UNIQUE
> UNIQUE?
contraint is implemented by means of an underlying index, which has a
maximum "key size" of approx. 240 bytes.
To work around your problem, short of waiting for a future release of
Firebird, I don't see much you can do. Perhaps you could split your
index in two or three (non unique) slices, and then enforce uniqueness
by means of a trigger or two.
This has some disadvantages, too.
Ciao
--
____
_/\/ando