I'm having some trouble getting the reset_db command extension to work with my postgres database. I get an error "psycopg2.OperationalError: cannot drop the currently open database" which looks like the same issue reported here.
I'm using django 1.0 and django_extensions 0.4.1, which I believe has the fix for the above issue included. So maybe I'm configuring something wrong either in postgres or in django, but syncdb seems to work fine so I'm not sure that's the problem either.
I'm using PostgreSQL 8.3 from the .dmg installer on OS X 10.5 and 'postgresql_psycopg2' for the DATABASE_ENGINE setting and psycopg2 version 2.0.10.
Another related question is that I'm using the database cache backend, and I'm not sure if reset_db would or should reset the cache table from the CACHE_BACKEND setting, or if that needs a separate custom command?