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

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: driver ODBC-PostreSQL, cursor and transaction isolation level
Дата
Msg-id 396486430904090714n8e4d32v93225a0d2a2ebd5e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: driver ODBC-PostreSQL, cursor and transaction isolation level  ("olivier dorie" <olivier.dorie@ign.fr>)
Список pgsql-odbc
On Thu, Apr 9, 2009 at 3:05 AM, olivier dorie <olivier.dorie@ign.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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "olivier dorie"
Дата:
Сообщение: Re: driver ODBC-PostreSQL, cursor and transaction isolation level
Следующее
От: "Jeff Wigal (Referee Assistant)"
Дата:
Сообщение: Problem with connection dropping