Thread: what is this error
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.
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.
am 03.04.2006, um 13:40:45 +0000 mailte venu gopal folgendes:
> Dear List,
> I have created a database called dhis13 and created a login role with user name venu and pwd gis now i have
createdan sql file using shp2pgsql command it worked successfully when i m importing the same to the dhis13 database i
wasgiving 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
All okay.
> 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.
This is the error: function addgeometrycolumn(....) does not exist.
> psql:e:/venu/postgischittoorshp.sql:4: ERROR: current transaction is aborted, c
> ommands ignored until end of transaction block
All errors now are only aftereffect.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
On 4/3/06, venu gopal <gopalonline2@yahoo.co.uk> wrote:
>
> 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 add explicit type casts.
You're missing a function called "addgeometrycolumn". It's not a
native postgres function (as far as I'm aware) - you'll have to find
where it comes from and import it.
--
Postgresql & php tutorials
http://www.designmagick.com/