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
11038	django tests using postgis	funkmyster	nobody	"When running our newly developed test suite for geolocation, I kept receiving:

{{{
createlang -d test_<projectDB> -U <username> plpgsql
Traceback (most recent call last):
  File ""./manage.py"", line 11, in <module>
    execute_manager(settings)
  File ""/usr/local/lib/python2.6/site-packages/django/core/management/__init__.py"", line 359, in execute_manager
    utility.execute()
  File ""/usr/local/lib/python2.6/site-packages/django/core/management/__init__.py"", line 304, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File ""/usr/local/lib/python2.6/site-packages/django/core/management/base.py"", line 195, in run_from_argv
    self.execute(*args, **options.__dict__)
  File ""/usr/local/lib/python2.6/site-packages/django/core/management/base.py"", line 222, in execute
    output = self.handle(*args, **options)
  File ""/usr/local/lib/python2.6/site-packages/django/core/management/commands/test.py"", line 23, in handle
    failures = test_runner(test_labels, verbosity=verbosity, interactive=interactive)
  File ""/usr/local/lib/python2.6/site-packages/django/contrib/gis/tests/__init__.py"", line 135, in run_tests
    create_test_spatial_db(verbosity=verbosity, autoclobber=not interactive)
  File ""/usr/local/lib/python2.6/site-packages/django/contrib/gis/db/backend/postgis/creation.py"", line 119, in create_test_spatial_db
    create_lang(db_name, verbosity=verbosity)
  File ""/usr/local/lib/python2.6/site-packages/django/contrib/gis/db/backend/postgis/creation.py"", line 25, in create_lang
    raise Exception(""Error executing 'plpgsql' command: %s\n"" % output)
Exception: Error executing 'plpgsql' command: 
}}}

apparently if 'plpgsql' is pre-installed on the newly generated instance:
{{{
createlang -d test_<projectDB> -U <username> plpgsql
}}}
...raises an exception with the value 2, thus breaking the test suite. Note my stack was built from source.





"		new	GIS	dev					Unreviewed	1	0	0	0