Skip site navigation (1) Skip section navigation (2)

Re: conflict txns in serialization isolation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yi LIN <ylin30(at)cs(dot)mcgill(dot)ca>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: conflict txns in serialization isolation
Date: 2004-07-23 20:26:11
Message-ID: 27729.1090614371@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Yi LIN <ylin30(at)cs(dot)mcgill(dot)ca> writes:
> Does anyone have the same problem as I? I am using postgresql7.2

Nope, not even in 7.2.

I kinda suspect that you are getting confused by JDBC autocommit
behavior and are having transactions commit when you thought they
were still open.  But without a complete example it's only speculation.

Your first gripe might also be explained by supposing that the
transactions are actually in read committed mode, and not serializable
mode at all.

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Yi LINDate: 2004-07-23 21:19:59
Subject: Re: conflict txns in serialization isolation
Previous:From: Yi LINDate: 2004-07-23 19:46:13
Subject: conflict txns in serialization isolation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group