[fpc-devel] PostgreSQL SQLdb transactions
cdryburghca at netscape.net
Thu Nov 6 17:10:13 CET 2014
On 06/11/14 10:22 AM, Martin Schreiber wrote:
> 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.
> fpc-devel maillist - fpc-devel at lists.freepascal.org
OK I suppose I had not gotten to the point of fully understanding how it
worked. Well Michael's patch should work for all databases and is close
to being put into trunk. Unless something happens porting the MSEgui
transaction handling approach to other databases should not be needed.
More information about the fpc-devel