Subject RE: [firebird-support] Primary Key Size Limit
Author Mike Metcalfe
Thanx Ann,

I don't know why I didn't received those replies. I'm porting an existing
app and I don't want to redesign anything yet.

And thanx to all who replied.


-----Original Message-----
[]On Behalf Of Ann W. Harrison
Sent: 19 April 2005 06:01
Subject: Re: [firebird-support] Primary Key Size Limit

Mike Metcalfe wrote:
> Hi,
> I asked this list about the primary key size limit of 255 chars the other
> day and got no replies. I'm new to Firebird and would like to know where
> the best place to ask get an answer.

This is a good place, and I thought I saw several answers. They can be
summarized as:

1) The limit is increased in Firebird2 to 1/4 of the page size.

2) Why are you using such a long primary key. There is a general but
not universal belief that primary keys should be artificial 64bit
integers that can be guaranteed stable.



Yahoo! Groups Links