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 ===