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

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Error with pg_dump (of data), with --role
Date: 2021-02-19 02:59:44
Message-ID: CAD3a31Xgm7_BQdmmA_KZ7KfcRBOeriHNvf215Ru5UQa1BtBQZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 18, 2021 at 5:23 PM Rob Sargent <robjsargent(at)gmail(dot)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....

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-02-19 03:16:25 Re: Error with pg_dump (of data), with --role
Previous Message Rob Sargent 2021-02-19 01:23:24 Re: Error with pg_dump (of data), with --role