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

[Düster Horst]

Try to use ogr2ogr

Horst

-----Ursprüngliche Nachricht-----
Von: Sung-Gheel Jang [mailto:sjang3 at uiuc.edu]
Gesendet am: Dienstag, 7. Januar 2003 23:59
An: Postgis-Users (E-mail)
Betreff: [postgis-users] PostgreSQL 7.3.1 and Shape file loading Error

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