Re: BUG #4860: Indexes gone after restore

"Obe, Regina" <robe.dnd@cityofboston.gov> writes:
> If you have an index on a function that calls another function where the function being called does not have the
namespacespecifically prefixed. 

This has nothing to do with either indexes or pg_dump.  A function that
calls another function, or references a table, or does much of anything
at all with other database objects, is responsible for schema-qualifying
those references if it expects to be callable with random settings of
search_path.

In some cases the most practical way to do this is to attach a "SET
search_path" option to the function rather than change its source code.
But in either case it's ultimately the function author's responsibility.

            regards, tom lane