[fpc-devel] PostgreSQL SQLdb transactions

[Chris Dryburgh]

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.
>
> Martin
> _______________________________________________
> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
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.