isolation level on the transaction

[nejamube]

Hi.

How I can change the isolation level on the transaction?

http://www.postgresql.org/docs/9.1/stat ... n-iso.html


Thanks.

[AlexP]

Hello,

For the time being, you can control the transaction behavior using the TPgTransaction class in the following way:

Code: Select all

uses ..., CRAccess;

var
  PgConnection: TPgConnection;
  PgTransaction: TPgTransaction;
begin
  PgConnection := TPgConnection.Create(nil);
  PgTransaction :=  TPgTransaction.Create(nil);
  PgTransaction.DefaultConnection := PgConnection;
  PgTransaction.IsolationLevel := ilRepeatableRead;
  PgTransaction.StartTransaction;

IsolationLevel is described in the CRAccess module and can take the following values:
ilReadCommitted, ilSnapshot, ilRepeatableRead, ilReadUncommitted

[nejamube]

Hi, thanks for your answer.

What I have to select for isolation serializable (ilSnapshot, ilRepeatableRead, ??)?

http://www.postgresql.org/docs/9.1/stat ... n-iso.html

Best Regards

[AlexP]

Hello,

To use Serializable Isolation Level, you should set the PgTransaction.IsolationLevel property to ilSnapshot.

Code: Select all

ilReadCommitted = READ COMMITTED
ilSnapshot = SERIALIZABLE
ilRepeatableRead = REPEATABLE READ
ilReadUncommitted = READ UNCOMMITTED