Magnus Hult ha scritto:
Hi,
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:
http://initd.org/tracker/psycopg/wiki/psycopg2_documentation#setting-transaction-isolation-levels
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
it.comp.lang.python newsgroup:
http://groups.google.com/group/it.comp.lang.python/browse_thread/thread/bf98fd21e78958e4
> [...]
Regards Manlio Perillo
_______________________________________________
Twisted-web mailing list
[email protected]
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-web
