Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHoE4-0000P4-I9 for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jul 2023 16:22:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHoE2-0007qk-Li for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jul 2023 16:22:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qHoE2-0007qa-Cd for pgsql-hackers@lists.postgresql.org; Fri, 07 Jul 2023 16:22:30 +0000 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHoDw-002Z7I-Pl for pgsql-hackers@postgresql.org; Fri, 07 Jul 2023 16:22:29 +0000 Received: by mail-pl1-x62b.google.com with SMTP id d9443c01a7336-1b852785a65so14637565ad.0 for ; Fri, 07 Jul 2023 09:22:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20221208.gappssmtp.com; s=20221208; t=1688746944; x=1691338944; 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=hE1805EoSPCXs9V+t6f5kXmxt2HhUp/DbZVfBqPwrbw=; b=z/1SpG9rSJr/Uj3QZIDAGZtKxMcrW4ivDPju/tys4DT6OUIxU15qmlUVNiPw/d87An +X9dudanXMtvAwAS7mdd9jhYfJpeQsXvlAgOPdNM2wv3w6sydu2gN2p5rgrAaR3WinAE tXLGdyOvSPHcEwKSOLz5k+IpNvy5S1UDVuTPmSPi1q2wj4cPLtybxq0+38VSAqEILQqM Sn+qVe0lorXof9KyDSBzhOVB7Moqm0I3hi9qQ6d2rH/i4zbNOiBvWp7JeGn9dsSiXmsN pmQBq/M/dUBkAPCROF939UP98Blzb0jpdDrJ4IcHWYs0HfnlEU15yvVOX67PO31JBjzg vUwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688746944; x=1691338944; 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=hE1805EoSPCXs9V+t6f5kXmxt2HhUp/DbZVfBqPwrbw=; b=Q/cPJLB7pLAGzfiLxDoDEJ68qLrMGJyd7n0h/aShtq64t4uc9eN++hKr6XrfN4nbBy XnHYCEZaTSuN+gbSwRA2DkmX7M6xnO+hV3KaPwiHaI6ztc8FzBPhXMkmSno3es81GU72 wlp89nzx2bLiKtqsnmPk7y8f87ax4BeDnHi0zaz6ifVobap/rrd9CKkYESUQ4J6Qe8QT /IwLbLwypqfoSTNMsAeRZ3pBVV9EDdlVzZZE+6jiBILh+MmtWsWTWHbEp0+6bJhopBOH /z9S6DKCtmZF/ybrUUcdyy8NZ5ARUOYWieTiwHNqIjGremg2YyO31YLNDzBRasFHnqgw 0nVA== X-Gm-Message-State: ABy/qLb0AuMZ+uMGiV2ZaUbduAQmZcSDyo/PWplg5VOYzVMm5Fx6fp/h IuA9opoQ+DXsOWDtppVo+3Y23A== X-Google-Smtp-Source: APBJJlGh+ULPhBLwum8oq/GbtMx4O9Mefuk3DYqxJV/wsmcbFPkh/cdb2mdzPc9ns0/budWFIO2sdA== X-Received: by 2002:a17:902:e5c5:b0:1b6:6a14:3734 with SMTP id u5-20020a170902e5c500b001b66a143734mr8886369plf.29.1688746943873; Fri, 07 Jul 2023 09:22:23 -0700 (PDT) Received: from jeff-laptop.lan (c-73-170-46-202.hsd1.ca.comcast.net. [73.170.46.202]) by smtp.gmail.com with ESMTPSA id u13-20020a17090341cd00b001b7fa81b145sm3455275ple.265.2023.07.07.09.22.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 07 Jul 2023 09:22:23 -0700 (PDT) Message-ID: <1130d49de6f6cb09714f702b7b01d0b7b471d370.camel@j-davis.com> Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. From: Jeff Davis To: Nathan Bossart Cc: Tom Lane , Robert Haas , Noah Misch , "pgsql-hackers@postgresql.org" Date: Fri, 07 Jul 2023 09:22:22 -0700 In-Reply-To: <20230707051427.GA3853884@nathanxps13> References: <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> <20230630050921.GA2640352@nathanxps13> <931c23465c331fc3d53073cdefa53bad464b0469.camel@j-davis.com> <20230706172004.GA3635686@nathanxps13> <20230707051427.GA3853884@nathanxps13> 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 Thu, 2023-07-06 at 22:14 -0700, Nathan Bossart wrote: > Since we are only reverting from v16, the REL_16_STABLE catversion > will be > bumped ahead of the one on master. I don't object to you doing it this way, but FWIW, I'd just revert in both branches to avoid this kind of weirdness. Also I'm not quite sure how quickly my search_path fix will be committed. Hopefully soon, because the current state is not great, but it's hard for me to say for sure. Regards, Jeff Davis