[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:  closed                
  Priority:  medium          |   Milestone:  PostGIS 2.1.1         
 Component:  tiger geocoder  |     Version:  2.1.x                 
Resolution:  worksforme      |    Keywords:  function soundex exist
-----------------------------+----------------------------------------------
Changes (by mpaul):

 * cc: mpaul (added)
  * status:  new => closed
  * resolution:  => worksforme


Comment:

 I'll elaborate on robe's very useful comment.

 I had the same problem, and decided to check the source code. In
 postgis-2.1.0/extensions/postgis_tiger_geocoder/sql/postgis_tiger_geocoder
 --2.1.0.sql , search_path is immediately set to its reset_val in
 pg_settings. To find out what value is being used, do:

 {{{SELECT reset_val FROM pg_settings WHERE name = 'search_path';}}}

 As robe suggested, I removed my own search_path ( {{{ALTER ROLE ... RESET
 search path;}}} ), changed the default search_path for the database (
 {{{ALTER DATABASE ... SET search_path ... ;}}} ) to include the schema in
 which I had created the fuzzystrmatch extension, logged out, logged back
 in, and successfully ran:

 {{{CREATE EXTENSION postgis_tiger_geocoder;}}}

 In psql, you can use {{{\df soundex}}} to find the name of the schema
 where fuzzystrmatch was installed. If you wish, you can {{{DROP}}} that
 extension and {{{CREATE}}} it in a different schema before proceeding.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2500#comment:3>
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.