[Twisted-web] Twisted and SQLAlchemy Cache Problem
manlio_perillo at libero.it
Wed Jun 13 09:08:01 EDT 2007
Magnus Hult ha scritto:
> When executing the following program, changes in the database (other
> than those made by this program) aren't visible until it is restarted,
> due to some form of SQLAlchemy caching:
Are you using PostgreSQL?
If this is the case, then give a look at:
psycopg1 has a SERIALIZED default isolation level, psycopg2 has a READ
COMMITED default isolation level.
The solution is: make sure to add a commit after every select.
You can read a discussion with the psycopg author in the
Regards Manlio Perillo
More information about the Twisted-web