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

[Mark Cave-Ayland]

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?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

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