On Sat, May 29, 2021 at 11:06 PM Joel Jacobson <joel@compiler.org> wrote:
Glad you bring this problem up for discussion, something should be done to improve the situation.
Personally, as I really dislike search_path and consider using it an anti-pattern.
I would rather prefer a GUC to hard-code search_path to a constant default value of just ‘public’ that cannot be changed by anyone or any function. Trying to change it to a different value would raise an exception.
That would work, too! I think it's a nice idea, perhaps even better than what I proposed. I would be happy to see either one incorporated.