I expect that only changes on step 2.7 persisted in DB. On Tue, May 4, 2010 at 11:18 PM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> On Tue, May 4, 2010 at 11:52 PM, Konstantin Izmailov <pgf...@gmail.com> > wrote: > > 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? > > What are you expecting to happen? >
