On Fri, Feb 19, 2021 at 4:21 PM Tom Lane <[email protected]> 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>* [email protected] (253) 245-3801 Subscribe to the mailing list <[email protected]?body=subscribe> to learn more about AGENCY or follow the discussion.
