Re: php with postgres

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