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 1qQx5k-0004HH-3I for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 21:39:44 +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 1qQx4i-000Rgf-RU for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Aug 2023 21:38:41 +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 1qQx4i-000RgW-Eg for pgsql-hackers@lists.postgresql.org; Tue, 01 Aug 2023 21:38:40 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQx4b-0000xu-P8 for pgsql-hackers@postgresql.org; Tue, 01 Aug 2023 21:38:39 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-1b9cdef8619so38687615ad.0 for ; Tue, 01 Aug 2023 14:38:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1690925912; x=1691530712; 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=OVuTL+kVDIANIqJMs7rUl8zRiQ5dMG8jc4ObYG82XLo=; b=IcIx0RJqVpkYO6P/h5wASeKLDyYz7OtvPx2wR9DJNbQOFSvsrDqcHK7Y0iSfhTKgZ9 ZwnjLASdbjmEqTup3Pa5PeRUAV9ZRpdcMuVz9tMSNDLr0ZFSvPbGS6RJuHDpaDYMXgxB +tj9RNd5TSb/PHR5yU1QalEJvQJ45JunAS4DWU0YRuKUT4+nLIWTZdtLU8H1185PBqpY XUVbo4sOOICFKJ1DL9xxo9HGBPUp9zqRS1188Ssu6jM/hT8VVNFEV0m+Nd7hbdquE9J/ O0luIcvJbZWMWPjCDKNz/6fGYKE2GYLmt0cI42/hOUDXS90ffus09xAx4MPFr955X1CB Raug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690925912; x=1691530712; 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=OVuTL+kVDIANIqJMs7rUl8zRiQ5dMG8jc4ObYG82XLo=; b=mDpCfV55i7MEmphSbyt5hA8Nxvim21C/EYDJyT0sTWm7kd4HveGIgF6ycuwOKpeC6W TU7+ASHF/kml7V9KjMvzZPI8deh9y5RcBbuzpguSpeMx1KZyhfLT8Esv3OkXyOOLEGGs vy5+dYFe0inlfc/dl46R0gI9prmLvnC5xyDHZ9gDOJOBX5mu7/6+ZIvy/733tml/JWNq VQRL4LubV0H8wJIMY5tfWLzhxA80y38yI/oiQsFT0TSSQ7gdtoZ8DNOON4l3KPG5NZIZ PydxYz4nkpRj4UmaT1gUMrDXeg4UmJLv7rXKWgkfdcRmTZGZzU2+tITtUtnRyEtcnx84 lqeA== X-Gm-Message-State: ABy/qLZ3o4NlEmkvPHKMFjYIrcPbgRgN446K4iRi3/avxhZfOzaJ51ba oD2DPp8nAQLNKlPh36fP0tPnsw== X-Google-Smtp-Source: APBJJlEUsh63VxsBEuPimxDRtmUGOuebj+anjMDm52UdUs0suJxuo0M17fisQuGAyxQ/BZYQ6fplaQ== X-Received: by 2002:a17:902:d482:b0:1b7:c166:f197 with SMTP id c2-20020a170902d48200b001b7c166f197mr16253907plg.29.1690925912631; Tue, 01 Aug 2023 14:38:32 -0700 (PDT) Received: from [172.24.1.43] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id u9-20020a17090341c900b001bbb25dd3a7sm10935915ple.187.2023.08.01.14.38.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 01 Aug 2023 14:38:32 -0700 (PDT) Message-ID: <3c6f92439fef0137b56d68eae54256296bda9320.camel@j-davis.com> Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. From: Jeff Davis To: "David G. Johnston" , Robert Haas Cc: Tom Lane , Noah Misch , "pgsql-hackers@postgresql.org" , Nathan Bossart Date: Tue, 01 Aug 2023 14:38:30 -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> 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 11:16 -0700, David G. Johnston wrote: > They can use ALTER FUNCTION and the existing "FROM CURRENT" > specification to get back to current behavior if desired. The current behavior is that the search_path comes from the environment each execution. FROM CURRENT saves the search_path at definition time and uses that each execution. Regards, Jeff Davis