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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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