[fpc-devel] Implicit Transactions Postgres
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
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
More information about the fpc-devel