[postgis-users] None
strk
strk at keybit.net
Mon Jan 12 09:50:20 PST 2004
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
More information about the postgis-users
mailing list