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.
Re: How to reproduce serialization failure for a read only transaction. |
Список | 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 по дате отправления: