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.
TransIsolation for PostgreSQL! How to set transaction isolation level?
-
- Posts: 9
- Joined: Wed 12 Dec 2012 19:36
Re: TransIsolation for PostgreSQL! How to set transaction isolation level?
Hello,
Transactions in dbExpress driver for PostgreSQL are set similarly to the other products:
Transactions in dbExpress driver for PostgreSQL are set similarly to the other products:
Code: Select all
SQLConnection.Params.Values['TransIsolation'] := 'ReadCommited';