вт, 24 июл. 2018 г. в 17:06, liviuslivius <liviusliv...@poczta.onet.pl>: > Is this possible that this CN(commit number) of transactions (pair > transaction id + CN) can be stored into some table?
CN is not stored at all. A list of CommitNumbers is generated looking into TIP on database init in memory. Then it's mainainted in memory. > Is it possible to retrive most recent CN from transaction start point (call > this recentCN). I guess it makes more sence to think about either request CN or snapshot transaction CN. In your example olny request CN in read committed transaction make sense. Snapshot transaction has no changes to see any new table updates. If provide a system function like RDB$REQUEST_CN and RDB$RECORD_CN which will get RDB$RECORD_VERSION, get related CN and return so I guess it's possible to implement. But note. All these allow you to select records from a table and remember REQUEST_CN. You have to select RECUEST_CN in the same request as select) Otherwise the next request will have its own new CN. > It can provide simple way to retrive new records/changes in tables (new > feature). -- Roman Simakov ------------------------------------------------------------------------------ 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
