[postgis-users] Our problems executing postgis.sql

[inna kobiak]

 We have trayed this but did not helped.
    Also replaced  all "$libdir" in the postgis.sql script with your absolute path "/usr/lib/postgresql"
    but we have the exact same errors , and we have checked makeŽs output and have seen this error:
        gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -I. -DFRONTEND -DSYSCONFDIR='"/usr/etc/postgresql"'  -DUSE_VERSION=74 -DUSE_STATS -fpic -I../../src/include -D_GNU_SOURCE   -c -o postgis_debug.o postgis_debug.c
        postgis_debug.c: at function `lockcheck':
        postgis_debug.c:310: warning: end of a non void function reached 
        gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions   -I. -DFR
    Regards.
    >> 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)
    >> 

- Ignored:
    >>      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,