Vote on SET in aborted transaction

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Vote on SET in aborted transaction
Дата
Msg-id 200204231627.g3NGRVq11398@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: Vote on SET in aborted transaction  (Bradley McLean <brad@bradm.net>)
Re: Vote on SET in aborted transaction  (Jan Wieck <janwieck@yahoo.com>)
Re: Vote on SET in aborted transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Vote on SET in aborted transaction  (Lamar Owen <lamar.owen@wgcr.org>)
Vote totals for SET in aborted transaction  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
OK, would people please vote on how to handle SET in an aborted
transaction?  This vote will allow us to resolve the issue and move
forward if needed.

In the case of:
SET x=1;BEGIN;SET x=2;query_that_aborts_transaction;SET x=3;COMMIT;

at the end, should 'x' equal:1 - All SETs are rolled back in aborted transaction2 - SETs are ignored after transaction
abort3- All SETs are honored in aborted transaction? - Have SETs vary in behavior depending on variable
 

Our current behavior is 2.

Please vote and I will tally the results.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "make report"
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Index Scans become Seq Scans after VACUUM ANALYSE