BUG #13940: rollback prepared is not working - Mailing list pgsql-bugs

From prathameshsonavane@gmail.com
Subject BUG #13940: rollback prepared is not working
Date
Msg-id 20160210104604.24153.46549@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13940: rollback prepared is not working  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13940
Logged by:          Prathamesh Sonavane
Email address:      prathameshsonavane@gmail.com
PostgreSQL version: 9.2.14
Operating system:   windows 7 enterprise
Description:

I am trying following prepared transaction:

(
BEGIN TRANSACTION;
PREPARE TRANSACTION 'B';
UPDATE xyz
SET   jkl=20 WHERE lmn="XX";
)

Now it will change value of jkl to 20.
Now i am executing following query b4 "commit prepared B":

(
rollback PREPARED 'B';
)


indeed..it shud set jkl to its old value.but, still its showing 20 after
issuing this command. its very annoying. :(

pgsql-bugs by date:

Previous
From: gsv371@ukr.net
Date:
Subject: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait
Next
From: Andres Freund
Date:
Subject: Re: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait