ODBC support

olivier dorie | 8 Apr 2009 14:38

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

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 ? Is it possible to
have a read committed level?

Regards
Olivier

-----Message d'origine-----
De : pgsql-odbc-owner <at> postgresql.org
[mailto:pgsql-odbc-owner <at> postgresql.org] De la part de Hiroshi Inoue
Envoyé : samedi 4 avril 2009 09:01
À : olivier dorie
Cc : pgsql-odbc <at> postgresql.org
Objet : Re: [ODBC] driver ODBC-PostreSQL, cursor and transaction isolation
level

olivier dorie wrote:
> Hello, 
>  
> 
> I have some problems to have a transaction isolation level serializable 
> with postgresql-ODBC driver for windows by using the ODBC cursor

(Continue reading)

headers

Hiroshi Inoue | 8 Apr 2009 16:27

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

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

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

(Continue reading)