Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

while i'm adding a geometry column in postgis by using AddGeometryColumn then the error is

no function matches the given name and argument types. you might need to add explicit type casts

Please Explain clearly

Thanks in advance.

share|improve this question
may be you could add the actual statement you are trying? – iant Oct 17 '12 at 7:32

i think because of these error arise from lack of postgis extension of postgres or not proper installation and its dependencies.

you can take more info here about proper installation.

sudo apt-get install pgadmin3 postgresql-9.1-postgis

i hope it helps you...

share|improve this answer
ya i got it by using default postgis data base "template_postgis" – satya chandra Oct 18 '12 at 9:30

If PostGIS is properly installed, is the schema you installed the PostGIS functions to in your search path? You can check by using

SHOW search_path;

By default the PostGIS functions are installed in the public schema, so if public's in your search path and you've either installed the PostGIS extension for PostGIS or run the old sql install script then you're probably not providing the correct arguments to AddGeometryColumn. Did you use single quotes around the schema, table, and column names? Did you leave the quotes off when supplying the SRID and dimension arguments?

share|improve this answer

As per the guides, the best test for determining whether your installation is correct is going to be via CREATE EXTENSION PostGIS; run from psql or PgAdmin.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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