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

[Sung-Gheel Jang]

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