Subject Re: [firebird-support] Maximum number of stored procedures?
Author Ivan Prenosil
>> 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.

Ivan