postgis_tiger_geocoder extension restore from backup fails
|Reported by:||robe||Owned by:||robe|
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.