Devart Forums

SET TRANSACTION ISOLATION LEVEL is called before BEGIN.

According to PostreSql documentation:

The SET TRANSACTION command sets the characteristics of the current transaction. It has no effect on any subsequent transactions.

If SET TRANSACTION is executed without a prior START TRANSACTION or BEGIN, it will appear to have no effect, since the transaction will immediately end.

http://www.postgresql.org/docs/9.2/stat ... ction.html

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.

Great.

Also it would be nice if you could fix minor incorrect behavior with COMMIT called after PREPARE TRNSACTION, though this is not error, but this produces a WARNING in PostgreSQL log, which 1) pollutes log file, making it hard to read, 2) slow down performance, because for every transaction warning line have to be written.

Explanation: when PREPARE TRANSACTION statement is executed the current transaction is promoted to Prepared and it's no longer associated with current session (connection), it is no longer considered a current transaction, so calling COMMIT will produce a warning telling that there is no current transaction in progress, only COMMIT PREPARED statement is needed.

Quote from PostgreSQL documentation:

Issuing COMMIT when not inside a transaction does no harm, but it will provoke a warning message.

We have fixed the bug with set transaction isolation level. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

We will also investigate the behavior with COMMIT called after PREPARE TRANSACTION and notify you about the results as soon as possible.

We have fixed the bug with executing COMMIT after COMMIT PREPARED with a distributed transaction. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

The new build of dotConnect for PostgreSQL 6.2.122 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=25285