Hi, I'm working on a solution that utilizes 2 phase commit protocol (between SQL Server and PostgreSQL). Normally PostgreSQL statements sequense is: 1. START 2. <inserts, updates, etc.> 3. PREPARE TRANSACTION 'uuid' 4. COMMIT PREPARED 'uuid'
What if on step 2 user application issues statements with SAVEPOINTs, e.g. 2.1. SAVEPOINT svp1 2.2. <inserts, updates, etc.> 2.3. SAVEPOINT svp2 2.4. <inserts, updates, etc.> 2.5. RELEASE SAVEPOINT svp2 2.6. ROLLBACK TO SAVEPOINT svp1 2.7. <inserts, updates, etc.> Is this allowed and safe to use? Thanks, Konstantin