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
17894	create_template_postgis-debian.sh fails on Ubuntu 11.10	John Paulett	nobody	"Ubuntu 11.10 upgraded to PostgreSQL 9.1, thus the path to the PostGIS files have changed again (to /usr/share/postgresql/9.1/contrib/postgis-1.5)

Additionally it appears that plpsql is now installed in the template database by default, resulting the failure of the createlang command, which causes following commands to not be executed:

{{{
createlang: language ""plpgsql"" is already installed in database ""template_postgis""
}}}

On a fresh Ubuntu 11.10 install:

{{{
$ sudo -u postgres psql
psql (9.1.3)
Type ""help"" for help.

postgres=# \dL
      List of languages
  Name   |  Owner   | Trusted 
---------+----------+---------
 plpgsql | postgres | t
(1 row)

}}}

The attached patch adds the path to PostgreSQL 9.1 and only runs createlang for older version."	Bug	closed	GIS	dev	Normal	duplicate		john@…	Unreviewed	1	0	0	0	0	0