[postgis-users] None

[inna kobiak]

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