what is this error

From: venu gopal <gopalonline2(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: what is this error
Date: 2006-04-03 13:40:45
Message-ID: 20060403134045.18901.qmail@web25609.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-04-03 13:54:31 Re: what is this error
Previous Message shakahshakah@gmail.com 2006-04-03 13:11:55 Re: 8.1.3, libpq, PQprepare, plpgsql function, and partitioned tables