Re: "interesting" issue with restore from a pg_dump with a database-wide search_path

Larry Rosenman <ler(at)lerctr(dot)org> writes:
> On Fri, Jul 06, 2018 at 11:35:41AM -0700, Joshua D. Drake wrote:
>> Knowing the errors would be helpful.

> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 12; 3079 887963 EXTENSION postgis_tiger_geocoder
> pg_restore: [archiver (db)] could not execute query: ERROR: function soundex(character varying) does not exist
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.

This looks like a problem with the postgis_tiger_geocoder extension.
It's depending on the fuzzystrmatch extension (which has the soundex
function), but seemingly this dependency is not declared in the
extension's control file. If it were, the search path would've been
set to include the schema of the fuzzystrmatch extension during
CREATE EXTENSION.

regards, tom lane