On 12/9/24 14:31, David G. Johnston wrote:
On Mon, Dec 9, 2024 at 3:14 PM PopeRigby <poperi...@mailbox.org> wrote:

    On 12/7/24 11:58, David G. Johnston wrote:
    On Sat, Dec 7, 2024 at 12:25 PM PopeRigby <poperi...@mailbox.org>
    wrote:


        It actually looks like setting those all to have public fixed
        all the
        errors, including the one with lldap. So, how can I get it to
        not put
        public there automatically for next time?


    I assume you mean "get it to put public there" (i.e., the "not"
    is a typo)

    You cannot.  The security team has decided to not permit an
    opt-in bypass of the lock-downs implemented to fix CVE-2018-1058.

    Your only real choice at the moment is to replace the function
    call in the generated expression with a custom function and in
    that custom function's create function command attach a "set
    search_path to public" clause.  That will prevent inlining and
    also ensure the public schema is in the search_path when
    executing the public.ll_to_earth function call.  With that in
    place the empty search_path in the dump file will no longer matter.

    Yeah, that was a typo. It seems weird that this behavior would be
    broken by default though, is there anything that could fix it
    upstream?


You saw and tried the work being done "upstream" to fix the situation. It's a big knot in the system and it isn't easy (or highly motivated) to untangle unfortunately...

David J.

Understood. Well, at least it was a fairly easy fix. Thanks for the help :)

Reply via email to