Subject Re: [firebird-support] Rdb$db_key inside triggers
Author Ivan Prenosil
> My replicator might not work after all...can this be fixed?

Since rdb$db_key values are guaranteed to be stable only inside transaction,
I wonder how your replication works ...

Ivan

----- Original Message -----
From: "Nigel Weeks" <nweeks@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, May 20, 2005 12:57 AM
Subject: RE: [firebird-support] Rdb$db_key inside triggers


>
>> SQL> select * from t2;
>>
>> F1 F2 F3
>> ============ ================ ======
>>
>> 1 8000000001000000 b/i
>> 1 8000000001000000 a/i
>> 2 8000000001000000 b/i
>> 2 8000000001000000 a/i
>>
>> SQL> select rdb$db_key from t1;
>>
>> DB_KEY
>> ================
>>
>> 0000008000000001
>> 0000008000000002
>>
>>
>> Note that the values for rdb$db_key are different in the log
>> table and
>> the actual table...
>
> WOW! Look at those differences!!!
> Could it be the character set used for the 'F2' field?
>
> Oh dear. My replicator might not work after all...can this be fixed?
> Is this a bug?
>
> Nige.