Re: Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block
Дата
Msg-id 20131129040425.GL5513@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block  (David Johnston <polobo@yahoo.com>)
Ответы Re: Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
David Johnston wrote:

> In all of these cases we are assuming that the user understands that
> emitting a warning means that something is being logged to disk and thus is
> causing a resource drain.
> 
> I like explicitly saying that issuing these commands is pointless/"has no
> effect"; being indirect and saying that the only thing they do is emit a
> warning omits any explicit explicit explanation of why.  And while I agree
> that logging the warning is an effect; but it is not the primary/direct
> effect that the user cares about.

Honestly I still prefer what I proposed initially, which AFAICS has all
the properties you deem desirable in the wording:

"issuing ROLLBACK outside a transaction emits a warning and otherwise has no effect".

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



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: MultiXact truncation, startup et al.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: TODO: Split out pg_resetxlog output into pre- and post-sections