25.09.2018 17:25, liviuslivius wrote:
Ok,
i supposed that this go further.
I need global CN from transaction start POV.
For snapshot\concurrency transaction you could obtain it using SNAPSHOT_CN
context variable. For read-comitted transaction it doesn't exists.
I do not know if i can retrive it in On Transaction Start Trigger?
Yes. And later too.
Is that trigger serialized?
No
If i start transaction no other transaction can be commited until this trigger
is finished?
Of coure there is no such limitations.
You know myTrStartCN:= GLOBAL_CN
If not then TransactinStartCN will be also needed.
As said above, it is available (and have sence) for non-RC transactions via
SNAPSHOT_CN
Also some virtual table with pair TN and CN should be available.
Query RDB$GET_TRANSACTION_CN function in a loop. Probably, you need
transaction IDs
from OIT to Next.
This will be good start point for some useful things.
Hope, it helps
Regards,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel