Skip site navigation (1) Skip section navigation (2)

Re: rollback to savepoint leads to transaction already in progress

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: David Newall <postgresql(at)davidnewall(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: rollback to savepoint leads to transaction already in progress
Date: 2010-10-14 08:36:49
Message-ID: AANLkTi=57XG-UX3ve3XOi_Mi62nQ3P+s_bbrQmwO1oMd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Thu, Oct 14, 2010 at 3:52 PM, David Newall
<postgresql(at)davidnewall(dot)com> wrote:
> This does seem to be an new bug in previously working code.  While any
> solution that fixes the problem is good, it might pay to look the code that
> worked before.  As reported, it worked for ecpg (PostgreSQL 8.3.8) 4.4.1.

It works on 8.3, but it's still broken. Here is the code in 8.3.
It ignores "ROLLBACK TO savepoint", but also ignores "ROLLBACK TRANSACTION".

----
if (strcmp(transaction, "commit") == 0 || strcmp(transaction, "rollback") == 0)
   con->committed = true;
else
   con->committed = false;
----

-- 
Itagaki Takahiro

In response to

pgsql-hackers by date

Next:From: Boszormenyi ZoltanDate: 2010-10-14 09:56:24
Subject: Re: ECPG FETCH readahead
Previous:From: Dean RasheedDate: 2010-10-14 07:39:15
Subject: Re: WIP: extensible enums

pgsql-bugs by date

Next:From: Michael MeskesDate: 2010-10-14 10:53:08
Subject: Re: rollback to savepoint leads to transaction already in progress
Previous:From: David NewallDate: 2010-10-14 06:52:25
Subject: Re: rollback to savepoint leads to transaction already in progress

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group