Re: [HACKERS] postgresql transactons not fully isolated

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [HACKERS] postgresql transactons not fully isolated
Дата
Msg-id CAKFQuwZAwL6jQRGMfJZyF-6GrpiKar2joaE91ytDsJddDqWRdQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] postgresql transactons not fully isolated  (Chapman Flack <chap@anastigmatix.net>)
Ответы Re: [HACKERS] postgresql transactons not fully isolated  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
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.

David J.



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

Предыдущее
От: Chapman Flack
Дата:
Сообщение: Re: [HACKERS] postgresql transactons not fully isolated
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [HACKERS] Optional message to user when terminating/cancelling backend