Subject Re: [firebird-support] delete duplicate row
Author Ann W. Harrison
Steve Wiser wrote:
> try using the rdb$db_key for this problem. just don't rely on it as a
> long term key since it changes after a backup/restore cycle I think.
>

The rdb$db_key is approximately the physical record address. When a
record is deleted, the rdb$db_key will be reused. So they're unstable
even while the database is running. However, they are stable for the
duration of a concurrency transaction and for the duration of a read-
write read-committed transaction.


Cheers,


Ann