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
way.

http://www.ibphoenix.com/main.nfs?
a=ibphoenix&l=;FAQS;NAME='System+Limits'

Adam

--- In firebird-support@yahoogroups.com, "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

increase

> the size of constraints to allow me to do this?
>
> Thanx in advance.
>
> Mike