Subject | Re: [firebird-support] cannot create generator |
---|---|
Author | unordained |
Post date | 2010-02-22T21:11:24Z |
---------- Original Message -----------
From: Helen Borrie <helebor@...>
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
From: Helen Borrie <helebor@...>
> What do you get back from------- End of Original Message -------
> select max(rdb$generator_id) from rdb$generators?
> ./heLen
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