On Tue, May 4, 2010 at 11:52 PM, Konstantin Izmailov <pgfizm@xxxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
