Subject Re: [firebird-support] cannot create generator
Author unordained
---------- Original Message -----------
From: Helen Borrie <helebor@...>
> What do you get back from
> select max(rdb$generator_id) from rdb$generators?
> ./heLen
------- End of Original Message -------

Ah-ha! Connecting to the saved database, I get: 32523.
After backup/restore, which fixed the problem, I get: 657.
I have scripts that help "build" the database from a meta description, and some
of the code just attempts DDL ("create generator ...") and in case of failure,
ignores/logs it. I'm guessing those failures are counting against my max
generators, and every once in a while I'll have to backup/restore to fix the
problem?

Thanks (as always) Helen!

-Philip