Subject RE: [ib-support] Generator RDB$SECURITY
Author Martijn Tonies
Hi Roger,

good question: where does this generator come from? Is it a system
generator? I've heard from an InterBase Workbench user (was it you?) that it
doesn't get flagged as a system generator -> and it becomes visible in
InterBase Workbench after the restore...

Any comments people, what is this generator, why does it appear and why
isn't it flagged as a system generator?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Using FB RC1

I have a database which Validates ok, backs up ok, but on restore, at the
last moment, reports an attempt to insert a duplicate value in a unique
index. The index in question turns out to be the index on the Generator
table. It also turns out that the database has a generator called
RDB$SECURITY, which is not present when a database is created from scratch.

If I delete the generator, backup and restore run without a problem.

I assume this generator is created and deleted as part of the Restore
procedure, and that at some point restore on this database failed before it
had a chance to delete. Now, the creation always fails because the
generator already exists.

[Non-text portions of this message have been removed]