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

[Obe, Regina DND\MIS]

Sounds to me like you've already got an entry in your geometry_columns table
pertaining to the geometry field you are trying to load (perhaps from a
prior load).  I would try removing that entry from your geometry_columns
table. 

-----Original Message-----
From: Sung-Gheel Jang [mailto:sjang3 at uiuc.edu]
Sent: Tuesday, January 07, 2003 5:59 PM
To: Postgis-Users (E-mail)
Subject: [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