[postgis-devel] Ubuntu packaging for PostGIS 1.5 does not support CREATE EXTENSION

[Sandro Santilli]

On Sun, Jun 02, 2013 at 08:56:01AM -0400, Stephen Woodbridge wrote:
> Hi all,
> 
> Daniel Kastl is setting up a Travis instance for pgRouting and we
> have run into an problem as follows:
> 
> We have pgrouting setup to install as an extension and it requires
> postGIS, in the control file.
> 
> The Ubuntu package for PostGIS 1.5 does not support CREATE EXTENSION.
> 
> We can install PostGIS 1.5 the old way using the sql files, but then
> pgRouting fails because it does not see the PostGIS extension.
> 
> I suppose we can remove the psql trap that prevents loading the
> pgrouting--2.0.0-dev.sql as a sql file and tells the user to use
> create extension.
> 
> Are there any better ways of handling this?

Can't you check for output of SELECT postgis_version() "manually"
to determine if postgis is available or not ?

--strk;