From: | AK <alkuzo(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | How to reproduce serialization failure for a read only transaction. |
Date: | 2014-01-06 19:41:16 |
Message-ID: | 1389037276585-5785569.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-01-06 19:48:42 | Re: dynamic shared memory and locks |
Previous Message | Robert Haas | 2014-01-06 19:22:10 | Re: ALTER SYSTEM SET command to change postgresql.conf parameters |