[postgis-users] PostgreSQL 7.3.1 and Shape file loading Error

[Paul Ramsey]

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
      \_