BUG #13940: rollback prepared is not working

Поиск
Список
Период
Сортировка
От prathameshsonavane@gmail.com
Тема BUG #13940: rollback prepared is not working
Дата
Msg-id 20160210104604.24153.46549@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13940: rollback prepared is not working
Список 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 по дате отправления:

Предыдущее
От: gsv371@ukr.net
Дата:
Сообщение: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #13941: Different value "pg_constraint.consrc" for similar Check Constrait