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

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

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
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-09 14:14:23
Message-ID: 396486430904090714n8e4d32v93225a0d2a2ebd5e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Thu, Apr 9, 2009 at 3:05 AM, olivier dorie <olivier(dot)dorie(at)ign(dot)fr> wrote:

> Since, I have made others tests with begintrans with (the driver 8.4.0100
> and the driver 8.3.4):
>
> ·         No dirty read
> ·         Read committed
> ·         Serializable
>
> I use the server settings or ExecuteSQL(“SET ISOLATION LEVEL ….”)
> All tests give good results.

Only Read Committed and Serializable are implemented in PostgreSQL all
other isolation levels default to one of these two:

http://www.postgresql.org/docs/8.3/interactive/sql-set-transaction.html


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

pgsql-odbc by date

Next:From: Jeff Wigal (Referee Assistant)Date: 2009-04-11 03:21:46
Subject: Problem with connection dropping
Previous:From: olivier dorieDate: 2009-04-09 10:05:53
Subject: Re: driver ODBC-PostreSQL, cursor and transaction isolation level

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