Re: [HACKERS] postgresql transactons not fully isolated

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [HACKERS] postgresql transactons not fully isolated
Дата
Msg-id CAHyXU0yEehjmNw99CRNjxw9i6uE0vzmM=MBnbvJhTJzsds2ONQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] postgresql transactons not fully isolated  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [HACKERS] postgresql transactons not fully isolated  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
On Tue, Jun 20, 2017 at 2:34 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> On Tue, Jun 20, 2017 at 12:22 PM, Chapman Flack <chap@anastigmatix.net> wrote:
>> I get the reported result (DELETE 0 and a table containing 2 and 3)
>> in both 'read committed' and 'read uncommitted'.
>
> Practically speaking those are a single transaction isolation mode.
>
> https://www.postgresql.org/docs/10/static/transaction-iso.html
>
> I think Merlin has mis-read the article he linked to.  The example
> being used there never claims to be done under serialization and seems
> to describe an example of the perils of relying on the default
> isolation level.

oops -- could be operator error :-)

merlin



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Something is rotten in publication drop
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Optional message to user when terminating/cancellingbackend