Re: [firebird-support] Re: Error : "There is at least one record with same fields values "
Author
Martijn Tonies
Post date
2006-09-26T15:07:23Z
----- 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.