How to reproduce serialization failure for a read only transaction.

Поиск
Список
Период
Сортировка
От AK
Тема How to reproduce serialization failure for a read only transaction.
Дата
Msg-id 1389037276585-5785569.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: How to reproduce serialization failure for a read only transaction.  (Florian Pflug <fgp@phlo.org>)
Re: How to reproduce serialization failure for a read only transaction.  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
If two transactions both read and write, I can easily reproduce the
following: "could not serialize access due to read/write dependencies among
transactions". However, the 9.3 documentation says that "When relying on
Serializable transactions to prevent anomalies, it is important that any
data read from a permanent user table not be considered valid until the
transaction which read it has successfully committed. This is true even for
read-only transactions".

I cannot have a read-only transaction fail because of serialization
anomalies. Can someone show me a working example please?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-reproduce-serialization-failure-for-a-read-only-transaction-tp5785569.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: ALTER SYSTEM SET command to change postgresql.conf parameters
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dynamic shared memory and locks