Re: Statement-level rollback - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Statement-level rollback
Date
Msg-id 20181207205007.4vfqsn2kup46z25x@alvherre.pgsql
Whole thread Raw
In response to Re: Statement-level rollback  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Statement-level rollback  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Statement-level rollback  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Statement-level rollback  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2018-Dec-07, Robert Haas wrote:

> More generally, whether or not we should "keep something away from our
> users" really depends on how likely the upsides are to occur relative
> to the downsides.  We don't try to keep users from running DELETE
> because they might delete data they want; that would be nanny-ism.
> But we do try to keep them from reading dirty data from an uncommitted
> transaction because we can't implement that without a risk of server
> crashes, and that's too big a downside to justify the upside.  If we
> could do it safely, we might.
> 
> From that point of view, this is doubtless not the worst feature
> PostgreSQL will ever have, but it sure ain't the best.

Well, look at this from this point of view: EnterpriseDB implemented
this because of customer demand (presumably).  Fujitsu also implemented
this for customers.  The pgjdbc driver implemented this for its users.
Now 2ndQuadrant also implemented this, and not out of the goodness of
our hearts.  Is there any room to say that there is no customer demand
for this feature?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Statement-level rollback
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Statement-level rollback