From: | Konstantin Izmailov <pgfizm(at)gmail(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Savepoint and prepared transactions |
Date: | 2010-05-06 03:47:42 |
Message-ID: | AANLkTilrAq8ZnhZiOX-YqSZbqetaI-FISfF_293smbUp@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yep, thank you!
On Wed, May 5, 2010 at 5:47 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> Should work. I'm not sure 2.5 release savepoint is necessary.
>
> On Wed, May 5, 2010 at 12:53 AM, Konstantin Izmailov <pgfizm(at)gmail(dot)com>
> wrote:
> > I expect that only changes on step 2.7 persisted in DB.
> >
> > On Tue, May 4, 2010 at 11:18 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> > wrote:
> >>
> >> On Tue, May 4, 2010 at 11:52 PM, Konstantin Izmailov <pgfizm(at)gmail(dot)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?
> >
> >
>
>
>
> --
> When fascism comes to America, it will be intolerance sold as diversity.
>
From | Date | Subject | |
---|---|---|---|
Next Message | AI Rumman | 2010-05-06 05:04:39 | how to get the deleted data |
Previous Message | Peter Hunsberger | 2010-05-06 02:57:36 | Re: alter table alter type CASCADE |