[postgis-users] PostGIS: make check works, but I can't manually create a spatial database
geopetrus at gmail.com
Fri May 28 08:08:24 PDT 2010
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
>> 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
> 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
> postgis-users mailing list
> postgis-users at postgis.refractions.net
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.
More information about the postgis-users