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
postgis
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
Best Answer
First, as others have said, make sure you have PostGIS installed. Run this command to ensure that you have PostGIS installed,
If you don't have
postgis_version()
then you need to install PostGIS on the database. If it's not installed, you can try this when connected to the specific database you want to install PostGIS on,If that fails than you need to install or build PostGIS which then becomes a question of what operating system you're using. If you've got the extension downloaded and installed, run this in
psql
If that works, then you have the function installed too but you're providing it the wrong types. We need the actual function call. Provide us what you're calling
AddGeometryColumn()
with. Also, if your version of PostGIS is newer than 2.0, do not useAddGeometryColumn()
. It is not needed. Instead use theALTER TABLE ADD COLUMN
with the subtype. Here is an example to add a geometry point in srs 4326.