Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQyyx-000AFe-DQ for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 23:40:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQyyv-0013Yo-Rq for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 23:40:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQyyv-0013Yg-Ie for pgsql-hackers@lists.postgresql.org; Tue, 01 Aug 2023 23:40:49 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQyyt-0001x8-DF for pgsql-hackers@postgresql.org; Tue, 01 Aug 2023 23:40:48 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-1bb9e6c2a90so49572475ad.1 for ; Tue, 01 Aug 2023 16:40:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1690933246; x=1691538046; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=piQ5WvQZ1JmGD7vjPhCOsUw5foXDFm2PlSWJMjzLBcg=; b=DtfgtSQdH1wcftivxQkLcV+uJe57r9Af9pt4rvz4KeMDcvRW1xs/pm0+KfeJEXpDnJ Zt1ZVMMYHCfxLVrJ1jt0QG689Fvz7wCWeGdwZFQpC97VrrPsJxx24B/0oyR6Y4yejK3x hkyBRc+B8xPBL6ZLv0lONdhkEmJK8bJ/2M4hebE5zy6cxsglqPoGVhY86Vw3Ti7Qut2o XGVIhHnHfioCGwD2o6Pr8/sE59z6aoy1yUKDSSraHDPT4+kKtL+Zx/LHZErOns41GetP TSzuCZyNve1BQQ2HyZq40X9TgJZo3B6HNMVqbGHLI4MoZcJ42farQSA+S2o0Fy2vByX7 dcmw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690933246; x=1691538046; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=piQ5WvQZ1JmGD7vjPhCOsUw5foXDFm2PlSWJMjzLBcg=; b=TsfN+Sba3S0kCmHTRfHBHE5uCUIqCxRV1MiQcnAoNFtKQKcBsK0JDT1GylgHLPMcLa rZRkA+jIGm69bLn1hYJts1g3iO4EgBnsZVyMLoqj/3jlPg/ZhV7Vzq+XgdgFSvAInJES 3EiypVGZMaS5WrhxE0jnuWmm4XKdFM46/BkAEVv8otDaZVdMSy5S9tJ9GhVH/PdF92Hx aN2B0iKnVUxDOgBoJxr5tqfQQtwAy2Jxn5qmhjEXARm2EneEYvCURFRyixBUpv6xRFBS t6hGEhT2aLTyxLtlH3+4c+S8tNMnu6rUqYNkwnpLxDk9g+x5YVzoUPr1U8tZ19pl64QE /x+A== X-Gm-Message-State: ABy/qLZuaXhqlCFaKhXEYOq3QIIG6BbLcCvlr+6M8Ho1beB2LKX5UAg6 k+ZExDDpaAEPbdnPrEBnZgRAMg== X-Google-Smtp-Source: APBJJlHOnr+nt85E3UUOoa6ocKk5C2X/JuwcYG20d0PnYQoqIefAX7ARxjzlvkS/hSAUYw38XzTfgQ== X-Received: by 2002:a17:902:a518:b0:1b5:5052:5af7 with SMTP id s24-20020a170902a51800b001b550525af7mr14828307plq.8.1690933246412; Tue, 01 Aug 2023 16:40:46 -0700 (PDT) Received: from [172.24.1.43] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id 17-20020a170902e9d100b001bb9883714dsm11003315plk.143.2023.08.01.16.40.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 01 Aug 2023 16:40:46 -0700 (PDT) Message-ID: Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. From: Jeff Davis To: "David G. Johnston" Cc: Robert Haas , Tom Lane , Noah Misch , "pgsql-hackers@postgresql.org" , Nathan Bossart Date: Tue, 01 Aug 2023 16:40:45 -0700 In-Reply-To: References: <89a415b86d5421941e4281ba5bf6288934078624.camel@j-davis.com> <573014.1686375211@sss.pgh.pa.us> <20230612170510.GA201972@gust.leadboat.com> <20230613182920.GA259321@gust.leadboat.com> <1799839.1686687804@sss.pgh.pa.us> <4df537f5a0d8c0ceac3eec3809d1144880b8e76d.camel@j-davis.com> <578fb4be80247570e6a05924908765a0b345971e.camel@j-davis.com> <43bbc9f7318057f51552d5986830908cb018dadf.camel@j-davis.com> <1659699.1688086436@sss.pgh.pa.us> <3c6f92439fef0137b56d68eae54256296bda9320.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2023-08-01 at 14:47 -0700, David G. Johnston wrote: > The overall point stands, it just requires defining a similar "FROM > SESSION" to allow for explicitly specifying the current default > (missing) behavior. That sounds useful as a way to future-proof function definitions that intend to use the session search_path. It seems like we're moving in the direction of search_path defaulting to FROM CURRENT (probably with a long road of compatibility GUCs to minimize breakage...) and everything else defaulting to FROM SESSION (as before)? Regards, Jeff Davis