postgresql transaction isolation levels
lazarus / 16-Databases

----------------------------------------------------------------------
tatamata · 2017-09-18 18:58

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 · 2017-09-19 12:27

https://www.postgresql.org/docs/current/static/sql-set-
transaction.html
QuoteREAD 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 · 2017-09-19 13:11

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

----------------------------------------------------------------------
sash · 2017-09-19 20:53

Quote from: tatamata on September 18, 2017, 08:58:15 pmHow 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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i   //
Execute this before actual query ASQLConnection.ExecuteDirect('set
transaction your_isolation_level;', ATransaction);