On Tue, 4 Nov 2014, Chris Dryburgh wrote:
Hi
In PostgreSQL it is considered poor practice to have long running idle
transactions.
https://encrypted.google.com/#q=postgresql+idle+in+transaction
This is a known problem, not only for postgres.
The problem is the open transaction for an open dataset: committing the
transaction (what you would normally do)
will close the dataset.
The solution for which I have code in place is a flag which tells the transaction that a connected dataset
should not be closed when the transaction is committed.
The transaction can then be committed or rollbacked as soon as the data is
fetched.
I have code for this in place that works for all connection types.
But it still needs to be checked through the testsuite.
Michael.
_______________________________________________
fpc-devel maillist - fpc-devel@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel