postgresql transaction isolation levels

[tatamata]

Hello,

How to set Postgresql transaction isolation level
(https://www.postgresql.org/docs/current/static/transaction-iso.html) with PQConnection?
What is default isolation level and how to change it?

[goodname]

https://www.postgresql.org/docs/current/static/sql-set-transaction.html

READ COMMITTED

    A statement can only see rows committed before it began. This is the default.

As far as I know the ability to change transaction isolation levels is a feature that has not been implemented in SQLdb.

[zeljko]

I don't use SQLDB but ZEOS, but AFAIR there was TSQLTransaction component with SQLDB.

[sash]

How to set Postgresql transaction isolation level with PQConnection?

https://www.postgresql.org/docs/9.6/static/sql-set-transaction.html

Try, this (not tested, just a guess).

Code: Pascal  [Select][+][-]

1.   // Execute this before actual query
2.  ASQLConnection.ExecuteDirect('set transaction your_isolation_level;', ATransaction);
3.