Hi,
question about this patch
https://github.com/FirebirdSQL/firebird/pull/105
Is this possible that this CN(commit number) of transactions (pair transaction
id + CN) can be stored into some table?
Is it possible to retrive most recent CN from transaction start point (call
this SCN).
It can provide simple way to retrive new records/changes in tables (new
feature).
E.g. whe can then do
SELECT * FROM TABLEX WHERE CN>:SCN;
I know this do not show us deleted records but in many scenarios it is not so
important.
Of course deleted records can also be tracked, if we block record versions to
be removed by garbage collector and make way to retrive this record with some
flag(?).
But this then require something what init this blocking mechanism (i suppose
this will be then simmilar feature to so called in Interbase Change Views).
What do you think about?
regards,
Karol Bieniaszewski
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
