[postgis-users] Our problems executing postgis.sql
inna kobiak
inna at satec.es
Tue Jan 13 03:13:46 PST 2004
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,
More information about the postgis-users
mailing list