Subject | Re: [firebird-support] Re: About CURRENT_TRANSACTION number |
---|---|
Author | Ivan Prenosil |
Post date | 2006-11-25T23:43:56Z |
>> But even with read only database each transaction will getHave you tried
>> unique transaction id,
>
> Actually, they don't. There's no place to store transaction ids,
> so a read-only database just uses the same number over and over.
SELECT CURRENT_TRANSACTION FROM RDB$DATABASE;
COMMIT;
SELECT CURRENT_TRANSACTION FROM RDB$DATABASE;
COMMIT;
SELECT CURRENT_TRANSACTION FROM RDB$DATABASE;
...
? The numbers will increase. (of course just in fb server, not in database)
Ivan