<div dir="ltr"><div>Howdy Gang,<br><br></div>Sorry if this question has been answer,
but I've been searching all morning and nothing has produced results so
far. When running a Rails migration, I received the following error:<br><br> ** [out :: <a href="http://staging-two.fart.org" target="_blank">staging-two.fart.org</a>] ActiveRecord::<div dir="ltr">StatementInvalid:
PG::AmbiguousFunction: ERROR: function addgeometrycolumn(unknown,
unknown, integer, unknown, integer) is not unique<br> ** [out :: <a href="http://staging-two.fart.org" target="_blank">staging-two.fart.org</a>] LINE 1: SELECT AddGeometryColumn('boundaries', 'boundary', 4326, 'PO...<br> ** [out :: <a href="http://staging-two.fart.org" target="_blank">staging-two.fart.org</a>] ^<br> ** [out :: <a href="http://staging-two.fart.org" target="_blank">staging-two.fart.org</a>] HINT: Could not choose a best candidate function. You might need to add explicit type casts.<br clear="all"><div><div><div><div dir="ltr"><br><br></div><div>After
some time on the Postgis IRC, a nice fellow told me to run `psql -d
fart_staging -f postgis_upgrade_21_minor.sql`. However, that returned:<br><br>DROP FUNCTION<br>psql:postgis_upgrade_21_minor.sql:53:
ERROR: cannot drop function addgeometrycolumn(character
varying,character varying,character varying,character
varying,integer,character varying,integer,boolean) because extension
postgis requires it<br>HINT: You can drop extension postgis instead.<br><br><br></div><div>Here is some relative info on my installation:<br><br>househappy_staging=# SELECT PostGIS_full_version();<br> postgis_full_version<br>-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br> POSTGIS="2.1.3
r12547" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009"
GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.8.0" LIBJSON="UNKNOWN"
TOPOLOGY RASTER<br>(1 row)<br><br>househappy_staging=# select version();<br> version<br>----------------------------------------------------------------------------------------------<br> PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit<br>(1 row)<br></div><div><br></div><div>Can
anyone help me understand and debug this issue? I have for sure updated
my postgis and postgresql a few time over the last two years starting
with 9.0. </div></div></div></div></div><div><div dir="ltr"><h1 style="font-family:Arial;background-color:rgb(255,255,255);color:rgb(33,162,249);font-size:17px;font-weight:normal;line-height:8px;margin:0px"></h1><br><hr height="1px" style="border-right-width:0px;border-bottom-width:0px;border-left-width:0px;min-height:0px;border-top-style:solid;border-top-color:rgba(0,0,0,0.098);color:rgb(85,85,85);font-family:Arial;font-size:10px;line-height:12px" color="#21a2f9" align="left" width="600px"><br style="background-color:rgb(255,255,255);line-height:12px;color:rgb(85,85,85);font-size:10px;font-family:Arial"><h1 style="background-color:rgb(255,255,255);line-height:4px;color:rgb(33,162,249);font-size:15px;margin:0px;font-family:Arial;font-weight:normal">Jake O'Brien Fagan</h1><p style="background-color:rgb(255,255,255);line-height:13px;color:rgb(85,85,85);font-size:10px;font-family:Arial">Ruby Engineer<br><a href="http://www.househappy.org/" style="color:rgb(33,162,249);text-decoration:initial!important" target="_blank">househappy.org</a><br><a href="https://www.facebook.com/househappy.org" style="color:rgb(33,162,249);text-decoration:initial!important" target="_blank"><font color="#555555">Facebook</font></a><font color="#555555"> |</font> <a href="https://twitter.com/househappy" style="color:rgb(33,162,249);text-decoration:initial!important" target="_blank"><font color="#555555">Twitter</font></a><font color="#555555"> |</font> <a href="http://instagram.com/househappy" style="color:rgb(33,162,249);text-decoration:initial!important" target="_blank"><font color="#555555">Instagram</font></a></p><table style="color:rgb(34,34,34);text-align:start;font-size:13px;font-family:arial,sans-serif;border:0px solid rgb(221,221,221)" border="0" cellpadding="0" cellspacing="0" width="600"><tbody><tr style="font-family:Times"><td style="font-family:arial,sans-serif;margin:0px;border-collapse:collapse" align="center" valign="top"><br></td></tr><tr style="font-family:Times"><td style="font-family:arial,sans-serif;margin:0px;border-collapse:collapse" align="center" valign="top"><br></td></tr></tbody></table></div></div>
</div>