Karol, > Take into account that user can rollback or commit oryginal transaction > before we copy all data to clone. Is this a problem or is simple to clone > transaction in atomic way?
Given that the clone would have the details of an **active** transaction, it would be isolated from any other transactions just as the active transaction would be. Read-committed/snapshot transactions only see data for transactions which were committed before the new transaction started, changes from any commit after that are not seen. So, there is no issue. Sean ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel