Subject Re: [firebird-support] Re: Error : "There is at least one record with same fields values "
Author Martijn Tonies
----- Original Message -----
From: "Ann W. Harrison"
> Martijn Tonies wrote:
> >
> > RDB$DB_KEY is fixed for the current transaction only.
> >
> There is an option to hold it for the duration of a transaction.
> If it became a major issue, we could make RDB$DB_KEY stable with
> little performance impact, though it would leave eight bytes of
> lost space for every deleted record.

Sorry, don't follow -- what do you mean by "for the duration of
a transaction"? As far as I understood, the db_key is valid for the
transaction that requested it, and valid as long as that transaction
hasn't been committed/rolled back.

Is that different from what you're saying?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!