[fpc-devel] PostgreSQL SQLdb transactions

[Martin Schreiber]

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.

Martin