On Fri, Feb 19, 2021 at 4:21 PM Tom Lane <tgl@xxxxxxxxxxxxx> 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
(253) 245-3801
learn more about AGENCY or
follow the discussion.
