On Tue, 25 Nov 2014, Chris Dryburgh wrote:
On 25/11/14 03:47 AM, Michael Van Canneyt wrote:
On Mon, 24 Nov 2014, Chris Dryburgh wrote:
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.
http://bugs.freepascal.org/view.php?id=17713
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.
Please check the sources, I have additionally implemented toUseImplicit. I
tested it using postgres (as firebird does not support it).
Michael.
_______________________________________________
fpc-devel maillist - [email protected]
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
It looks like implicit transaction code went in a couple of days ago. Seams
to only apply to Postgres
And MySQL also.
Michael.
_______________________________________________
fpc-devel maillist - [email protected]
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
