[postgis-users] PostgreSQL 7.3.1 and Shape file loading Error
Paul Ramsey
pramsey at refractions.net
Tue Jan 7 16:30:39 PST 2003
Probably you are trying to create a table for which there is already an
entry in GEOMETRY_COLUMNS.
Sung-Gheel Jang wrote:
> Hello all,
>
> When I was trying to load a shape file (line network), I got following error
> messages:
>
> -- error message start --
> $shp2pgsql uiucnw uiuncw mydb > uiucnw.sql
> $psql -d mydb -f uiucnw.sql
> CREATE TABLE
> psql:uiucnw.sql:2: WARNING: Error occurred while executing PL/pgSQL function
> addgeometrycolumn
> psql:uiucnw.sql:2: WARNING: line 39 at execute statement
> psql:uiucnw.sql:2: ERROR: Cannot insert a duplicate key into unique index gc_ok
> BEGIN
> psql:uiucnw.sql:4: ERROR: pg_atoi: zero-length string
> psql:uiucnw.sql:5: ERROR: current transaction is aborted, queries ignored until
> end of transaction block
> psql:uiucnw.sql:6: ERROR: current transaction is aborted, queries ignored until
> end of transaction block
> psql:uiucnw.sql:7: ERROR: current transaction is aborted, queries ignored until
> end of transaction block
> psql:uiucnw.sql:8: ERROR: current transaction is aborted, queries ignored until
> end of transaction block
> psql:uiucnw.sql:9: ERROR: current transaction is aborted, queries ignored until
> end of transaction block
> psql:uiucnw.sql:10: ERROR: current transaction is aborted, queries ignored
> until end of transaction block
> psql:uiucnw.sql:11: ERROR: current transaction is aborted, queries ignored
> until end of transaction block
> COMMIT
> -- error message end --
>
> My system environment:
> - SuSE Linux 8.0
> - PostgreSQL 7.3.1
> - PostGIS CVS version (Jan 3, 2003)
>
> A strange thing is that I can load some other shapfiles into the PostgreSQL DB
> (say mydb).
>
> Any idea or explanation? Thanks,
>
> Sung-Gheel Jang
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_
More information about the postgis-users
mailing list