Sure, with 32-bit integers that is a possibility. Add 100 records
every second and you run out of integers in just over a year. Though
with such a datavolume, you should consider 64-bit integers. I expect
it to be possible to run out of them too, but my guess is that it
takes a few more years until we start hearing about people with that
extreme requirements.

Set

--- In firebird-support@yahoogroups.com, "martinknappe" wrote:
> > If you need a consecutive number for a particular reason, I would
> > then NOT use it as the primary key, i.e. just have a second
> > column/field for it.
>
> no, that's not the point.
> i was only thinking that at some stage i may run out of id's...