>I said:
> > No, the RDB$DB_KEY is fixed for the life of the record.

At 05:48 PM 3/11/2002 +0100, Martijn Tonies wrote:

>What happened with 'valid for the current transaction only'?

Turns out to be the same thing. While a snapshot transaction
is active, any record that was committed when the transaction
started will not be garbage collected until after the transaction
commits. A db_key is never reused unless the record that held
it before has been garbage collected. So, as long as a snapshot
transaction is active, its db_keys will be stable. There's
large chance that a large number of them will be stable longer,
but no guarantees.


Regards,

Ann
www.ibphoenix.com
We have answers.