| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Wigal (Referee Assistant) | 2009-04-11 03:21:46 | Problem with connection dropping |
| Previous Message | olivier dorie | 2009-04-09 10:05:53 | Re: driver ODBC-PostreSQL, cursor and transaction isolation level |