Re: Statement-level rollback

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Statement-level rollback
Дата
Msg-id 20181207205007.4vfqsn2kup46z25x@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Statement-level rollback  (Robert Haas <robertmhaas@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Statement-level rollback
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Statement-level rollback