[fpc-devel] PostgreSQL SQLdb transactions
mse00000 at gmail.com
Thu Nov 6 16:22:33 CET 2014
On Thursday 06 November 2014 15:43:03 Chris Dryburgh wrote:
> I understand that but I don't think your approach allows for a series of
> read-only queries to be run in a single transaction batch.
Why not? Activate the datasets with dso_offline, the activation of the first
dataset will start the transaction. Rollback or commit the transaction after
loading all datasets. If one later calls "applyupdates" the dataset
automatically starts a new transaction either by "transactionwrite" if
assigned or the regular "transaction" property. If dso_autocommit is set
there will be also an automatic commit.
Transaction option tao_fake is off of course.
More information about the fpc-devel