[postgis-users] problems running postgis.sql

odain2 at mindspring.com odain2 at mindspring.com
Sun Jul 25 12:03:46 PDT 2004


I have downloaded and installed postgis and all the required dependencies.  I 
downloaded the suse 9.1 rpms from:

http://postgis.refractions.net/rpms/suse/9.1/

and installed everything there including the version of postgresql provided 
there on my suse 9.1 box.  Everything installed without a problem.  I then 
set up a new database and ran createlang without a problem.  However, when I 
try load the postgis.sql file I get the following errors:

oliver at marmaduke:contrib$ psql -U postgres -d GIS -f postgis.sql
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

psql:postgis.sql:44: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:49: NOTICE:  argument type histogram2d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:65: NOTICE:  type "box3d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:70: NOTICE:  argument type box3d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:85: NOTICE:  type "spheroid" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:90: NOTICE:  argument type spheroid is only a shell
CREATE FUNCTION
CREATE TYPE

etc.

After reading some of the posts to this list I tried editing postgis.sql and 
replacing all the $libdir instances with the full path to libpostgis.so.0.8.  
That didn't help.  I also tried defining and exporting a shell variable 
called $libdir whose value is the path to libpostgis, but again this didn't 
help.  Any ideas???

Thanks,
Oliver



More information about the postgis-users mailing list