Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
