Home > mailing lists

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

From	Ken Tanzer
Subject	Re: Error with pg_dump (of data), with --role
Date	February 19, 2021 05:59:44
Msg-id	CAD3a31Xgm7_BQdmmA_KZ7KfcRBOeriHNvf215Ru5UQa1BtBQZA@mail.gmail.com Whole thread Raw
In response to	Re: Error with pg_dump (of data), with --role (Rob Sargent <robjsargent@gmail.com>)
Responses	Re: Error with pg_dump (of data), with --role (Rob Sargent <robjsargent@gmail.com>) Re: Error with pg_dump (of data), with --role (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

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....