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

[samclemmens]

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.




Mark Cave-Ayland-3 wrote:
> 
> samclemmens wrote:
> 
>> Sorry; I inadvertently posted my previous response twice...   The line
>> is:
>> 
>> psql:postgis/postgis.sql:80: ERROR:  type "spheroid" already exists
>> 
>> So, does this mean that my spatial database was successfully created the
>> first time around despite the "notices" that the spatial functions (e.g.,
>> st_max_distance) do not exist?
> 
> Older versions of 1.5 tried to remove some legacy functions from the 
> database as part of the installation which is why some people would see 
> error messages at the end of the installation.
> 
> Since all the SQL functions are now in a transaction, then if you can 
> call any PostGIS function then the installation has completed correctly.
> Does "SELECT postgis_full_version()" work for you? If so, you should be 
> fine.
> 
> 
> HTH,
> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/PostGIS%3A-make-check-works%2C-but-I-can%27t-manually-create-a-spatial-%09database-tp28691440p28708126.html
Sent from the PostGIS - User mailing list archive at Nabble.com.