[postgis-tickets] [PostGIS] #2545: postgis_tiger_geocoder extension restore from backup fails

[PostGIS]

#2545: postgis_tiger_geocoder extension restore from backup fails
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  critical        |   Milestone:  PostGIS 2.1.2
Component:  tiger geocoder  |     Version:  2.1.x        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Just ran into this issue that when


 {{{
 CREATE EXTENSION postgis_tiger_geocoder;
 }}}

 is restored via just plain restore of backup, it fails with


 {{{
 ERROR: function soundex(character varying) does not exist
 }}}


 This might be because we have fuzzystrmatch installed in non-public schema
 or because tiger itself is installed in tiger so the backup might be
 setting schema search_path to just tiger.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2545>
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.