Subject Re: Constraint too big
Author Adam
Hi Mike,

A varchar of that size wouldn't jump out at me as a good candidate
key to use as the primary key. Any table that you wanted to reference
that table using a foreign key constraint would bloat.

Perhaps if you can tell us what you are trying to do someone can help
you come up with a better way to do it.

Here are some of the FB limitations. I think that some of these are
being increased in FB2, but in this case I am sure there is a better


--- In, "Mike Metcalfe"
<mmetcalfe@i...> wrote:
> Hi,
> I'm trying to create a primary key with a VARCHAR(255) field and I
get error
> msg 335544351 "key size too big for index". Is there any way to
> the size of constraints to allow me to do this?
> Thanx in advance.
> Mike