Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
Importing with configuration: ind_adm2, public, geom, C:\Program Files\OpenGeo\OpenGeo Suite\webapps\geoserver\india map\IND_adm2, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=0
Shapefile type: Polygon
PostGIS type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."ind_adm2" (gid serial,
"id_0" int4,
"iso" varchar(3),
"name_0" varchar(75),
"id_1" int4,
"name_1" varchar(75),
"id_2" int4,
"name_2" varchar(75),
"nl_name_2""
Failed in pgui_exec(): ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 17: SELECT AddGeometryColumn('public','ind_adm2','geom','0','MUL...
                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Shapefile import failed.
share|improve this question

closed as not a real question by Devdatta Tengshe, PolyGeo, Fezter, Aaron, whuber Jun 20 '13 at 14:05

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Welcome to GIS Stack Exchange? Unfortunately, it is not clear what your precise question is so would you be able to expand upon it with more text explanation, please? –  PolyGeo Jun 20 '13 at 8:27

1 Answer 1

Looks like your postgis installation is not complete. See http://stackoverflow.com/questions/13132649/osm2pgsql-function-addgeometrycolumn-doesnt-exist for a similar situation.

You might refer to the tutorials at http://workshops.opengeo.org/postgis-intro/.

If you are running postgis 2.0, some commands may have beeen renamed.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.