Postgres Pro
Downloads
Home   >   mailing lists

Re: Error with pg_dump (of data), with --role - Mailing list pgsql-general

From Rob Sargent
Subject Re: Error with pg_dump (of data), with --role
Date
Msg-id 17C9259A-500D-44AB-9290-0CB1ED81A34E@gmail.com
Whole thread Raw
In response to Re: Error with pg_dump (of data), with --role  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Tree view


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




On Thu, Feb 18, 2021 at 5:23 PM Rob Sargent <robjsargent@gmail.com> 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”?

pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Error with pg_dump (of data), with --role
Next
From: Tom Lane
Date:
Subject: Re: Error with pg_dump (of data), with --role