TransIsolation for PostgreSQL! How to set transaction isolation level?

TransIsolation for PostgreSQL! How to set transaction isolation level?

Postby eurides.baptistella » 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.
eurides.baptistella
 
Posts: 9
Joined: Wed 12 Dec 2012 19:36

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

Postby AlexP » 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';
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for PostgreSQL