Postgres Pro
Downloads
Home   >   mailing lists

Re: Serialization errors in Postgres 9.4.0 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Serialization errors in Postgres 9.4.0
Date
Msg-id 5166.1435251453@sss.pgh.pa.us
Whole thread Raw
In response to Serialization errors in Postgres 9.4.0  (BRUSSER Michael <Michael.BRUSSER@3ds.com>)
List pgsql-hackers
Tree view 
BRUSSER Michael <Michael.BRUSSER@3ds.com> writes:
> Some time ago we upgraded from v. 8.4.4 to 9.4.0 and we are seeing errors in some regression tests.
> LOCATION:  exec_simple_query, postgres.c:887
> ERROR:  40001: could not serialize access due to read/write dependencies among transactions

9.1 substantially tightened Postgres' ideas of what "serializable" means.
If you want to go back to the behavior you had in 8.4, use REPEATABLE READ
isolation level instead of SERIALIZABLE.
        regards, tom lane

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Serialization errors in Postgres 9.4.0
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Should we back-patch SSL renegotiation fixes?