[postgis-users] problems running postgis.sql

[Gregory S. Williamson]

Oliver --

The messages in the message below seem to be normal warnings from the postGIS definition. If there was nothing other than "NOTICE..." messages I would guess that you installed the postGIS module successfully. Try running the sql to define the "spatial_ref_sys.sql" (part of the postGIS module) ... if that suceeds then you did indeed create postGIS successfully. If not, post back to the list with the rest of the output from the original install and from the failed attempt at making the spatial reference system entries.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:	odain2 at mindspring.com [mailto:odain2 at mindspring.com]
Sent:	Sun 7/25/2004 12:03 PM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] problems running postgis.sql
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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users