From: | Dirk Koschuetzki <dkoschuetzki(at)gmx(dot)de> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Default mode for transaction in postgreSQL and JDBC |
Date: | 2000-07-04 17:20:41 |
Message-ID: | 39621CE9.22B3DBE8@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)medialift(dot)com
OpenPGP messages welcome
Fingerprint: E0C4 74F1 9E21 8C90 EEA7 A65A 1868 A81D 5622 74C4
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-07-04 19:58:19 | Re: Upper characters in database names |
Previous Message | Dave Page | 2000-07-04 16:33:29 | RE: Exporting access tables using odbc |