Re: what is this error - Mailing list pgsql-general

From A. Kretschmer
Subject Re: what is this error
Date
Msg-id 20060403135431.GE31755@webserv.wug-glas.de
Whole thread Raw
In response to what is this error  (venu gopal <gopalonline2@yahoo.co.uk>)
List 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
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    ===

pgsql-general by date:

Previous
From: venu gopal
Date:
Subject: what is this error
Next
From: "chris smith"
Date:
Subject: Re: what is this error