Re: Mark a transaction uncommittable
От | Cary Huang |
---|---|
Тема | Re: Mark a transaction uncommittable |
Дата | |
Msg-id | 168607821164.1146.8208653981413482075.pgcf@coridan.postgresql.org обсуждение исходный текст |
Ответ на | Re: Mark a transaction uncommittable (Gurjeet Singh <gurjeet@singh.im>) |
Список | pgsql-hackers |
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation: not tested Hello It is one of those features that a handful of people would find useful in specific user cases. I think it is a nice to havefeature that safeguards your production database against unwanted commits when troubleshooting production problems. Yourpatch applies fine on master and I am able to run a couple tests on it and it seems to do as described. I noticed thatthe patch has a per-session variable "default_transaction_committable" that could make all transaction committable oruncommittable on the session even without specifying "begin transaction not committable;" I am wondering if we should havea configurable default at all as I think it should always defaults to true and unchangable. If an user wants a uncommittabletransaction, he/she will need to explicitly specify that during "begin". Having another option to change defaultbehavior for all transactions may be a little unsafe, it is possible someone could purposely change this default tofalse on a production session that needs transactions to absolutely commit, causing damages there. thank you Cary Huang ------------------ Highgo Software Canada www.highgo.ca
В списке pgsql-hackers по дате отправления: