Patryk Zawadzki skrev 2010-09-06 12.20:
On Mon, Sep 6, 2010 at 11:20 AM, Kirit Sælensminde (kayess) <kirit.saelensmi...@gmail.com> wrote:
--- snip ---
You can check this by creating a fresh project using psycopg2 and creating a model. Then write a view that queries the database and invoke it. Now, leaving the server running, open up your database shell. The pg_stat_activity table will report "<IDLE> in transaction" for hours.
I'm not sure what you think you are doing but if you end up with "<IDLE> in transaction" that means you have not commited your transactions. For instance, open two connections with psql and run BEGIN in one and then take a look at pg_stat_activity you will have that connection marked as idle in transaction. I believe you are confused about isolation levels. They control the visibility of transactions. Regards, roppert -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
