[postgis-users] None

[strk]

Try loading postgis_undef.sql first, it seems you had postgis
installed before.

--strk;

inna 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