Postgres Pro
Downloads
Home   >   mailing lists

Default mode for transaction in postgreSQL and JDBC - Mailing list pgsql-interfaces

From Dirk Koschuetzki
Subject Default mode for transaction in postgreSQL and JDBC
Date
Msg-id 39621CE9.22B3DBE8@gmx.de
Whole thread Raw
List pgsql-interfaces
Tree view 
Hello,

I played around with the transaction management in postgreSQL and I found
that the JDBC-Driver allways indicates that the transaction isolation
level is "serializable". This is hard coded within the source and changing
the transaction isolation level with the provided method gives an
exception. So far so good.
A second look in the postgreSQL source code (V 6.5.3) indicates that the
default isolation level is read commited, the documentation states the
same and a check with psql confirms this. 

So, is the transaction isolation level within my (6.5.3) JDBC-Version
really serializable?

Regards 
Dirk

Ps.: Please CC me, as I'm currently not subscribed to the list.

-- 
Dirk Koschützki                       dkoschuetzki@medialift.com
OpenPGP messages welcome
Fingerprint:  E0C4 74F1 9E21 8C90 EEA7  A65A 1868 A81D 5622 74C4

pgsql-interfaces by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Upper characters in database names
Next
From: Peter Mount
Date:
Subject: RE: Default mode for transaction in postgreSQL and J DBC