| Lists: | pgsql-general |
|---|
| 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 |
| 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.
| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: what is this error |
| Date: | 2006-04-03 13:54:31 |
| Message-ID: | 20060403135431.GE31755@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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 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
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 ===
| From: | "chris smith" <dmagick(at)gmail(dot)com> |
|---|---|
| To: | "venu gopal" <gopalonline2(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: what is this error |
| Date: | 2006-04-03 13:58:36 |
| Message-ID: | 3c1395330604030658g59649ec1g383bca882cc28278@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 4/3/06, venu gopal <gopalonline2(at)yahoo(dot)co(dot)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/