> >> Check system tables. E.g. RDB$GENERATOR_ID is SMALLINT too,
> >> so the limit is the same.
> >
> > This isn't true - there's another limit to the number of generators
> > which has to do with the (generator) page size of a database, so
> > the limit is a per-database specific thingy.
> >
> > But I cannot remember exactly how and why... :-)
>
> You are talking about bug that was fixed about five years ago,
> so you can save memory space by deleting that info :-)
>
> I just created 32000 generators just fine.
> And I couldn't create 60000, so the limit is 32k.

Ah, well, that's alright then :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com