Devart Forums

Posted: **Wed 12 Dec 2012 19:48**

How should I set the isolation level of a transaction in postgresql using Delphi+DBExpress+DevartPostgreSQL ?

In Firebird: SQLConnection.Params.Values['DevartInterBase TransIsolation'] := 'ReadCommited'
In Oracle: SQLConnection.Params.Values['Oracle TransIsolation'] := 'ReadCommited'
In SQL Server: SQLConnection.Params.Values['SQLServer TransIsolation'] := 'RepeatableRead'

And PostgreSQL? I am facing a problem of Deadlock and believe it is the isolation level of the transaction that is causing errors.

Posted: **Thu 13 Dec 2012 13:16**

Hello,

Transactions in dbExpress driver for PostgreSQL are set similarly to the other products:

Code: Select all

SQLConnection.Params.Values['TransIsolation'] := 'ReadCommited';

Devart Forums

TransIsolation for PostgreSQL! How to set transaction isolation level?

TransIsolation for PostgreSQL! How to set transaction isolation level?

Re: TransIsolation for PostgreSQL! How to set transaction isolation level?