[postgis-users] None

[Johannes Buehler]

Hi 
i run in the exact same errors as you did, when i compiled postgis for the first time. 
the solution is quite simple.
replace all "$libdir" in the postgis.sql script with your absolute path eg: 
"/usr/local/pgsql/lib"

Johannes

On Mon, 12 Jan 2004 18:32:05 +0100
inna kobiak <inna at satec.es> wrote:

> Hi postgis-users,
> 
> I have installed PostgreSQL 7.4 and Postgis-0.8.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
> 3.2 20020903 (Red Hat Linux 8.0 3.2-7). I am having problems executing postgis.sql.  This is the
> way I make it: 
> 		
> 	cd /opt/postgresql-7.4/contrib/postgis	
> 	
> 	Editing Makefile I change the value of USE_STATS to 1	(USE_STATS=1)
> 
> 	make
> 	make install 
> 	
> 	...OK at this point, but when I try to execute:
> 	su postgres
> 	psql -d template1 -f /usr/share/postgresql/contrib/postgis.sql
> 
> 	The result is:
> 
> BEGIN
>         message
> ------------------------
>  PL/PgSQL is installed.
> (1 row)
> 
> psql:/usr/share/postgresql/contrib/postgis.sql:41: NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:46: NOTICE:  argument type histogram2d is only a
> shell CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql/contrib/postgis.sql:62: NOTICE:  type "box3d" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:67: NOTICE:  argument type box3d is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql/contrib/postgis.sql:82: NOTICE:  type "spheroid" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:87: NOTICE:  argument type spheroid is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql/contrib/postgis.sql:102: NOTICE:  type "wkb" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:107: NOTICE:  argument type wkb is only a shell
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:116: NOTICE:  type "chip" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:121: NOTICE:  argument type chip is only a shell
> CREATE FUNCTION
> CREATE TYPE
> psql:/usr/share/postgresql/contrib/postgis.sql:137: NOTICE:  type "geometry" is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:142: NOTICE:  argument type geometry is only a
> shell
> 
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> psql:/usr/share/postgresql/contrib/postgis.sql:240: NOTICE:  CREATE TABLE / PRIMARY KEY will
> create implicit index "spatial_ref_sys_pkey" for table "spatial_ref_sys" CREATE TABLE
> psql:/usr/share/postgresql/contrib/postgis.sql:260: NOTICE:  CREATE TABLE / PRIMARY KEY will
> create implicit index "geometry_columns_pk" for table "geometry_columns"
> psql:/usr/share/postgresql/contrib/postgis.sql:260: ERROR:  relation "geometry_columns" already
> exists psql:/usr/share/postgresql/contrib/postgis.sql:267: ERROR:  current transaction is aborted,
> commands ignored until end of transaction block
> psql:/usr/share/postgresql/contrib/postgis.sql:268: ERROR:  current transaction is aborted,
> commands ignored until end of transaction block...
> ...
> 
> Any advice would be appreciated, 
> cham
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users