| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | Ken Tanzer <ken(dot)tanzer(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 03:16:25 |
| Message-ID: | 17C9259A-500D-44AB-9290-0CB1ED81A34E@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Feb 18, 2021, at 8:00 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
>
>
>
>
>> 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....
>
> --
Do you need to set role at all?
Can you put the function in “public”?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-02-19 04:44:36 | Re: Error with pg_dump (of data), with --role |
| Previous Message | Ken Tanzer | 2021-02-19 02:59:44 | Re: Error with pg_dump (of data), with --role |