On Fri, Feb 19, 2021 at 4:21 PM Tom Lane <t...@sss.pgh.pa.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.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
