TransIsolation for PostgreSQL! How to set transaction isolation level?

[eurides.baptistella]

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.

[AlexP]

Hello,

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

Code: Select all

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