Re: A very puzzling backup/restore problem - Mailing list pgsql-general

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> On 10/24/19 2:58 PM, stan wrote:
>> So, it appears that this means that the function cannot be found, even if it is in the new
>> (default) schema.

> The original error was not about finding the function it was about not
> finding the table in the function:

> psql:task_instance.dump:55: ERROR:  relation "permitted_work" does not exist
> LINE 3:                 permitted_work
>                          ^

> You need to schema qualify the table name inside  the function.

Or attach a SET clause to the function, so that it executes with a
known search_path regardless of the session's prevailing path.

            regards, tom lane