BeginReq = False

[martinrame]

Hi, I've been having problems with transactions in postgresql (8.2 to be more specific).

My settup was:

BeginReq = False (default)
TransactionIsolationLevel=tiReadCommited

Using this, I can issue an StartTransacction, some commands, Commit or Rollback. It works well for some time, but...taking a look at Server Status in PgAdmin III, I see a lot of "<IDLE> in transaction" and after a couple of minutes, Postgres logs a "Unexpected EOF at client connection". The problem only occurs when Zeos sends commands to fetch table/query metadata to retrieve fields info after I send a Select (Dataset.Open), when I send Inserts or Updates (inside transactions) the problem doesn't appears.

I'd try BeginReq=True, and found transactions are ignored, the same result as using AutoCommit=True.

Can you check this?

Thanks in advance,
Leonardo.

[drakorg]

Hi, how can you change the default value for BeginReq?
Cause i want zeos to execute a 'BEGIN' when i do a startTransaction(), and for the moment I just go

myDbCon.DbcConnection.CreateStatement.ExecuteQuery('BEGIN TRANSACTION');

Thanks.