Hello Jan,
Tuesday, July 22, 2003, 10:57:56 PM, you wrote:
JW> Bruce Momjian wrote:
>> Marcus B?rger wrote:
>>> However it may be very usefull to terminate any open transaction before
>>> reusing a persisten connection. Typically this happens when the same script
>>> runs again. But anyway using transactions together with persistent conenctions
>>> in a multithreaded environment isn't the best thing you could do. So our
>>> options are
>>> 1) tell the users to do 'auto commit mode'
>>> 2) nested transactions
>>> 3) locking
>>>
>>> >From my perspective 2) and 3) are bad ideas for the web environment. In other
>>> words i guess we should leave it as is with transaction rollback only when the
>>> client terminates (e.g. the webserver stops).
>>
>> I don't see why you wouldn't just do BEGIN;COMMIT;RESET ALL; when you
>> pass the connection to a new client.
>>
JW> Right, and I don't see why using transactions in a multithreaded
JW> environment would be a bad idea. However an application is designed, one
JW> logical unit of changes, called a business transaction, has to have one
JW> database transaction modifying the business relevant information.
JW> There could be other transactions involved for dialog handling and
JW> advisory locking.
So i'll update to "BEGIN;COMMIT;RESET ALL;" :-)
--
Best regards,Marcus mailto:marcus.boerger@post.rwth-aachen.de