Re: Length limit of 500 on primary keys?

[Shankar Unni]

Steve Meyers wrote:

> The problem is that he has it as a primary key, so he wants it to be

> unique as well as indexed.  The best solution (and MUCH MUCH MUCH 

 > more efficient) would be to hash each of the four columns, and create
 > a primary key on that.  Integer keys are much faster and memory-
 > efficient than string keys.

Granted, but there's still the problem that the hash may not be unique, 
thus defeating the purpose of the primary key.

I really need a longer primary key. Why is there a limit in the first 
place, and if there *is* a limit, why is it not configurable at runtime or 
database creation time?
--
Shankar.