[fpc-devel] Implicit Transactions Postgres

Chris Dryburgh cdryburghca at netscape.net
Tue Nov 25 00:22:28 CET 2014

Found this bug report from 2010 on using implicit transactions in 
PostgreSQL. As far as I can tell nothing has happened since. Using the 
TSQLTransaction.Action setting looks like a good approach to 
implementing implicit transactions. It would mean warning users about 
setting action as it currently does nothing and is likely ignored by 
many programmers.


There is another reason to use implicit transactions. When creating or 
dropping a database the query must be run in a implicit transaction. 
Currently createDB and dropDB use implicit transactions but do not allow 
for options beyond the required database name.

Implementing implicit transactions will compliment the transaction patch 
from Michael. His patch allows automatically opened transactions to be 
closed without closing datasets which allows for user managed 
transaction handling.

More information about the fpc-devel mailing list