From: "Ann W. Harrison" <aharrison@...>

> > Although I agree that generators are the most error-free methods for
> > generating IDs, I also use the method the OP is using for other things.

It's

> > especially useful when you don't know ahead of time how many counters

you

> > need and they can be created any time. Generators are limited in number

for

> > any one database.
> >
>
> You can have 32K generators in a database which is a whole lot more than
> the number of bigint fields you can have in a table.

For older databases, though, the number is limited to 256 right? I haven't
switched everything over to FB2 yet and doubtful I will for some smaller
clients so they will still be limited in generator numbers.

Woody (TMW)