[postgis-tickets] [PostGIS] #2500: function soundex(character varying) does not exist

[PostGIS]

#2500: function soundex(character varying) does not exist
------------------------------------+---------------------------------------
 Reporter:  mikem                   |       Owner:  robe 
     Type:  defect                  |      Status:  new  
 Priority:  medium                  |   Milestone:       
Component:  tiger geocoder          |     Version:  2.1.x
 Keywords:  function soundex exist  |  
------------------------------------+---------------------------------------
 Version info: "PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by
 gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit POSTGIS="2.1.0 r11822"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.9.2, released 2012/10/08" LIBXML="2.7.6" LIBJSON="UNKNOWN" RASTER"

 @ http://postgis.net/install, I am following the "Getting Started" >
 "Enabling PostGIS" > "Run the following SQL" instructions.

 The last successful instruction I can execute is "CREATE EXTENSION
 fuzzystrmatch;"

 The next statement fails "CREATE EXTENSION postgis_tiger_geocoder"

 The message is:
 ERROR: function soundex(character varying) does not exist
 SQL state: 42883
 Hint: No function matches the given name and argument types. You might
 need to add explicit type casts.
 Character: 56874

 Background:
 I was able to successfully execute all CREATE EXTENTION commands before
 when I was using, and had, the "public" schema which is included in a
 default installation. Having followed recommendations to remove the
 "public" schema, I removed these extensions and dropped the "public"
 schema. Then I created a "postgis2" schema, set my search_path to it and
 for good measure altered my login to default to the new "postgis2" schema.
 Then started executing the CREATE EXTENSION commands again and got stuck
 as noted above. I have verified that function soundex(text) exist in my
 new "postgis2" schema along with 1058 other functions.

 The only change from when this worked to when it broke is that when it
 worked, the installation schema was the "public" schema and it does not
 work when the public schema is dropped and I install use a custom schema.

 I tried to resolve the issue by reverting with:
 drop extension fuzzystrmatch cascade;
 drop extension postgis_topology cascade;
 drop extension postgis cascade;
 drop schema postgis2 cascade;
 create schema public;
 set search_path to public;
 alter user michael set search_path to public;
 CREATE EXTENSION postgis;
 CREATE EXTENSION postgis_topology;
 CREATE EXTENSION fuzzystrmatch;
 CREATE EXTENSION postgis_tiger_geocoder;

 ... but the problem persists.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2500>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.