[postgis-users] PostGIS: make check works, but I can't manually create a spatial database

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Fri May 28 08:11:36 PDT 2010

samclemmens wrote:

> Unfortunately, I get the following:
> postgres=# SELECT postgis_full_version();
> ERROR:  function postgis_full_version() does not exist
> LINE 1: SELECT postgis_full_version();
>                ^
> HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.

Okay so something has gone wrong somewhere. Firstly, after "make check", 
did you run "make install"? Secondly, what happens if you load the 
postgis.sql file into a brand new database?



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list