[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:  PostGIS 2.1.1
Component:  tiger geocoder          |     Version:  2.1.x        
 Keywords:  function soundex exist  |  
------------------------------------+---------------------------------------

Comment(by robe):

 I do recall their being an issue with CREATE EXTENSION fuzzystrmatch being
 installed in topology schema if you install right after topology, but
 can't think of an easy way out of that.

 Try installing fuzzystrmatch first.


 The error usually means that where you have fuzzstrmatch is not in your
 search_path
 or the account you are using doesn't have rights to the installed schema.

 Make sure that postgis2 is in your database search path with command
 something like


 {{{
 ALTER DATABASE gisdb
   SET search_path = "$user", postgis2, tiger_geocoder,topology;
 }}}


 I would avoid setting your user profile to specific search paths.  That's
 just asking for trouble unless you know what you are doing and can
 remember that you did it for a specific role.

 Do a:
 {{{
 ALTER ROLE michael RESET search_path;
 }}}

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