On 2018-07-24 10:13, liviuslivius wrote:
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).
The term SCN is already used by nbackup, lets not muddle the waters by
overloading it for another usecase.
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;
You may want to look at RDB$RECORD_VERSION introduced in Firebird 3, see
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk02ch03s05.html#d0e5251
and https://www.ibphoenix.com/resources/documents/contributed/doc_393
Mark
------------------------------------------------------------------------------
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
