From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, "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-20 00:38:34 |
Message-ID: | CAD3a31WHgQJi7+joVVxibN5s64WO2s2LvfRD76nYHatYQX7-XA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Feb 19, 2021 at 4:21 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Yeah, that would be slightly safer. If the public schema is
> world-writable, though, you're in big trouble anyway ...
>
>
Sorry, you lost me with the last sentence. My scenario is that public
_isn't_ world-writable. But everyone can set their own temp objects. So
these would be found first unless pg_temp is explicitly specified at the
end of the search path.
And I guess that's a "No" on an option to show the complete search path. :)
Thanks again for your help!
Ken
--
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2021-02-20 00:38:39 | Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached |
Previous Message | Tom Lane | 2021-02-20 00:21:53 | Re: Error with pg_dump (of data), with --role |