Re: Mark a transaction uncommittable - Mailing list pgsql-hackers

From Cary Huang
Subject Re: Mark a transaction uncommittable
Date
Msg-id 168607821164.1146.8208653981413482075.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Mark a transaction uncommittable  (Gurjeet Singh <gurjeet@singh.im>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Let's make PostgreSQL multi-threaded
Next
From: Jeff Davis
Date:
Subject: Re: Order changes in PG16 since ICU introduction