On Thu, Jan 27, 2005 at 01:40:36AM +0200, Ksenia Marasanova wrote:
-> On Tue, 25 Jan 2005 11:38:36 +0100, Massa, Harald
->  wrote:
-> > Please... also bear in mind:
-> >
-> > as long as AUTOCOMMIT is NOT set to true ... every "SELECT" without
-> > "COMMIT" will keep an connection in active state.
-> >
-> > which is far more bad in terms of database status.
-> >
-> > Harald
-> >
->
-> And I think related problem is that a different Quixote process will
-> not see the changes in the db...

This is the major reason to use transactions, is it not?

I do a rollback() on each reused psycopg connection before handing it
off to a new function, and I do a rollback() each time a request is
finished, too.  That way anything not commit()ed is thrown away at
the end of a request, and the connection can see anything newly
commit()ed when a new request is handled.

cheers,
--titus