Savepoint and prepared transactions

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Savepoint and prepared transactions
Date: 2010-05-05 05:52:40
Message-ID: AANLkTil2xfv8m-nTZlMDMdbZ01KdlJ_rDxKv8KSGKu4o@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerd Koenig 2010-05-05 06:05:46 no such file euc2004... while initdb 9.0Beta
Previous Message Amol Chiplunkar 2010-05-05 05:42:08 Table alias and inherited tables