what is this error - Mailing list pgsql-general

From venu gopal
Subject what is this error
Date
Msg-id 20060403134045.18901.qmail@web25609.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: what is this error
Re: what is this error
List pgsql-general
Dear List,
    I have created a database called dhis13 and created a login role with user name venu and pwd gis now i have created an sql file using shp2pgsql command it worked successfully when i m importing the same to the dhis13 database i was giving with the following error all the database and loginroles is created at pgadminIII (not at command prompt)
   When i try to import i was getting the following error

C:\Program Files\PostgreSQL\8.1\bin>psql -U venu -d dhis13 -f e:\venu\postgischi
ttoorshp.sql
Password for user venu:
BEGIN
psql:e:/venu/postgischittoorshp.sql:2: NOTICE:  CREATE TABLE will create implici
t sequence "chittoor_ver0_gid_seq" for serial column "chittoor_ver0.gid"
psql:e:/venu/postgischittoorshp.sql:2: NOTICE:  CREATE TABLE / PRIMARY KEY will
create implicit index "chittoor_ver0_pkey" for table "chittoor_ver0"
CREATE TABLE
psql:e:/venu/postgischittoorshp.sql:3: ERROR:  function addgeometrycolumn("unkno
wn", "unknown", "unknown", "unknown", "unknown", integer) does not exist
HINT:  No function matches the given name and argument types. You may need to ad
d explicit type casts.
psql:e:/venu/postgischittoorshp.sql:4: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:5: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:6: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:7: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:8: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:9: ERROR:  current transaction is aborted, c
ommands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:10: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:11: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:12: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:13: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:14: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:15: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:16: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:17: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:18: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:19: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:20: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:21: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:22: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:23: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:24: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:25: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:26: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:27: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:28: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:29: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:30: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:31: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:32: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:33: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:34: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:35: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:36: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:37: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:38: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:39: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:40: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:41: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:42: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:43: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:44: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:45: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:46: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:47: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:48: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:49: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:50: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:51: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:52: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:53: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:54: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:55: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:56: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:57: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:58: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:59: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:60: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:61: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:62: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:63: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:64: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:65: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:66: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:67: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:68: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:69: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:70: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:71: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:72: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:73: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:74: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:75: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:76: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:77: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:78: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:79: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:80: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:81: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:82: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:83: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:84: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:85: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:86: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
psql:e:/venu/postgischittoorshp.sql:87: ERROR:  current transaction is aborted,
commands ignored until end of transaction block
ROLLBACK

C:\Program Files\PostgreSQL\8.1\bin>

Why this error actually comes .what are the changes i have to make.Please give me the suggestions regarding..

Thanks in advance,
Regards,
venu.

pgsql-general by date:

Previous
From: Kai Hessing
Date:
Subject: Re: Performance Killer 'IN' ?
Next
From: "A. Kretschmer"
Date:
Subject: Re: what is this error