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

Re: driver ODBC-PostreSQL, cursor and transaction isolation level

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: olivier dorie <olivier(dot)dorie(at)ign(dot)fr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: driver ODBC-PostreSQL, cursor and transaction isolation level
Date: 2009-04-08 14:27:08
Message-ID: 49DCB43C.9000505@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Olivier,

olivier dorie wrote:
> Hiroshi,
> 
> Thank you for your answer.
> 
> I try the 2 solutions (BeginTrans and the driver 8.4.0100) and the two of
> them work: in the small test, I describe in the last mail, the transaction
> is serializable.
> 
> I have a last question: with BeginTrans or with the driver  8.4.0100, the
> transaction isolation level is every time serializable ?

Why do you think so?
Your example doesn't seem to show us the difference.

 > Is it possible to
> have a read committed level?

It's determined by the server setting. The default is read committed.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: olivier dorieDate: 2009-04-09 10:05:53
Subject: Re: driver ODBC-PostreSQL, cursor and transaction isolation level
Previous:From: olivier dorieDate: 2009-04-08 12:38:40
Subject: Re: driver ODBC-PostreSQL, cursor and transaction isolation level

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