Page 1 of 1

How and When Start a Transaction with PostgreSQL 8.1

Posted: 26.06.2007, 15:52
by leodinei
Hello.
I'm using zeos 6.5.1 with Delphi 7.
If I set TransactIsolationLevel = tiReadCommited in the Connection, I always have a Transaction open.
If I set TransactIsolationLevel to tiReadCommited just before open a transaction e and change back to tiNone after commit this don't happen.
I think this is the correct way to work. I'm right? There are some way to do this automatically?
And how work around when I have a transaction inside another?

Thanks.

Posted: 02.07.2007, 19:37
by msantos-rj
Hello. I think you should just to use the AutoCommit = True and TransactIsolationLevel = tiReadCommited. with this settings Zeos will implicity start a new transaction after a commit or rollback. a transaction inside another will not be possible with the zeosconnection, maybe if you control it by using SQL queries that manages these transactions.

I'm using zeos 6.5.1 with Delphi 7.
If I set TransactIsolationLevel = tiReadCommited in the Connection, I always have a Transaction open.
If I set TransactIsolationLevel to tiReadCommited just before open a transaction e and change back to tiNone after commit this don't happen.
I think this is the correct way to work. I'm right? There are some way to do this automatically?
And how work around when I have a transaction inside another?

Thanks.