2

SQL Exception

I am new to this field. I want to save my shapefile as a dataset in PostGIS using openJUMP, but I'm getting an error. Can anybody suggest a solution for this?

  • Which OpenJUMP and PostGIS versions? – user30184 Jun 27 '14 at 15:16
  • OpenJUMP1.7.1 and PostGIS 2.1.3 – user32934 Jun 27 '14 at 15:37
  • now am tried postgis import/export manager...can't import shp file into postgis...its also same error... – user32934 Jun 27 '14 at 15:41
  • Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist LINE 25: SELECT AddGeometryColumn('public','chennai','geom','0','MULT... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. – user32934 Jun 27 '14 at 15:43
  • What do you get with select postgis_version(); – user30184 Jun 27 '14 at 16:16
2

The OpenJUMP error message resends the error from PostgreSQL database. The message tells that AddGeometryColumn function does not exist and that indicates that the GIS database is missing PostGIS. PostGIS extension is not installed automatically to new databases but it must be explicitly installed by using SQL

CREATE EXTENSION postgis;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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