id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
20656	"test db spatial extentsion not created when using new postgis 2.0 ""CREATE EXTENSION postgis;"" method"	monkut	nobody	"Following the directions here:

https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/postgis/#creating-a-spatial-database-with-postgis-2-0-and-postgresql-9-1

I created my database using the new ""CREATE EXTENSION postgis;"" method and then attempted to run tests using the standard, manage.py test, but it appears that test does not properly add the necessary postgis extensions and errors with:


{{{
DatabaseError: type ""geometry"" does not exist
LINE 7:     ""center"" geometry(POINT,3122),
}}}

In addition, I attempted to define the POSTGIS_VERSION in my settings.py file thinking this might just be undocumented, but even after adding this, the same error above is still seen.

https://docs.djangoproject.com/en/1.5/ref/contrib/gis/testing/#postgis-version


I guess the work around is to revert to using the create postgis template method.

It would be nice if testing was supported when the ""CREATE EXTENTSION"" method is used, but if not supported, at least update the docs to mention testing can't be done when this method is used.
"	Uncategorized	closed	Uncategorized	1.5	Normal	needsinfo		flavio.curella@…	Unreviewed	0	0	0	0	0	0