Re: Error with pg_dump (of data), with --role

[Rob Sargent <robjsargent@xxxxxxxxx>]

On Feb 18, 2021, at 8:00 PM, Ken Tanzer <ken.tanzer@xxxxxxxxx> wrote:



On Thu, Feb 18, 2021 at 5:23 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:

>
> There is only one schema, public.
>
>

I suspect it is because "set role" doesn't "set search_path"

I'm not sure what you mean or are suggesting by that.  Is there something I'm supposed to do to set the search path?  Is that a known bug in pg_dump?  Something else?  As mentioned, there is only one schema....  

--

Do you need to set role at all? 

Can you put the function in “public”?