[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: A very puzzling backup/restore problem
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2019-10-24 22:11:40
Message-ID: 12087.1571955100 () sss ! pgh ! pa ! us
[Download RAW message or body]
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 e=
xist
> 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic