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 1qHqEV-0006yI-82 for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jul 2023 18:31:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qHqEU-0003zz-3f for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jul 2023 18:31:06 +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 1qHqET-0003zp-Pe for pgsql-hackers@lists.postgresql.org; Fri, 07 Jul 2023 18:31:05 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qHqEQ-002a0u-6C for pgsql-hackers@postgresql.org; Fri, 07 Jul 2023 18:31:04 +0000 Received: by mail-pf1-x42e.google.com with SMTP id d2e1a72fcca58-6686ef86110so1340247b3a.2 for ; Fri, 07 Jul 2023 11:31:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688754661; x=1691346661; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=yKVDWSSn2HSos5sOLyuxRipdHnfe5EhWZgbvXF1mXH8=; b=Ur8Sws4DbaSr9yivTm7t/RLsqaZ9dZdJxGV5hvF5ra5j9OBOHdnAM6kwauAxDfIKVi VKfbFS+ygkwegIjiaivayD5egkAI68r6V4FhOOXKLj03sLvqF+QAbVLF4si+rFvGgTvt ls7/UDyK4Fs1LS1wUJQuuCz8Y3MDiDRQueY7ZQzEEzCNEmIXzxOVZNjyuXas9UPXF1L0 7NQoxhhTTKBuwZ8RXF1wLvMEO7PKDEZkBXlVPBP+SRimsbn2fqGsvCY0l1whomLSzgIL omHp14uS5uZBFn29pNCNwhNKkPOhuyYMeyZVUW7ltYgqJFZOKjn+DrFHeEeZzQPrLq2t OjKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688754661; x=1691346661; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=yKVDWSSn2HSos5sOLyuxRipdHnfe5EhWZgbvXF1mXH8=; b=WvrZqnG3VPHuxFClXF5ShmHGS9wVcxXG++T1nimrjd2m+VWfK+c1YhY6N+K8YMPBle fJpc3bAv2uBUVSO2+EhRhfwC5KsI073hlO0C94zWrh8MJyjHXw7+mSexb2/vsmclwLri kgIWumD14ozyVcK0z1ePWPGV+Q/U8PitHWWpqUXazJp+uzEYT04bME0qURcf6nc0EOUX aVNJBMb+K4KkM/qLeC8K4d6ITbUKaAxqPoyRBMe0UqAHnJnNy+Y4vuRwzgSf33qqWcJH GpgSpk/OFlC+x9uZGb5rPPBYC5AnzWR4GW3ZWRmIzRqTBx3m6QOy0UDx0XRHffPHPuEu 78xw== X-Gm-Message-State: ABy/qLZDdpeib4vcaR8IjiBE8EIZEJHKYpwvWpAIHNpXV7/Lkw/htQRg o/NAgBU1osrsXtz0spduJb4= X-Google-Smtp-Source: APBJJlEDnJCaMvL83OIzSRzEfl4MSCi38Wwh8zg13mNiXq9wUHyjiERXaM8QyoBtAlvw4KXHYTM7+Q== X-Received: by 2002:a05:6a00:1354:b0:66a:5466:25bd with SMTP id k20-20020a056a00135400b0066a546625bdmr6475592pfu.15.1688754661181; Fri, 07 Jul 2023 11:31:01 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id m12-20020aa78a0c000000b0067f2f7eccdcsm3166807pfa.193.2023.07.07.11.31.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 07 Jul 2023 11:31:00 -0700 (PDT) Date: Fri, 7 Jul 2023 11:30:59 -0700 From: Nathan Bossart To: Jeff Davis Cc: Tom Lane , Robert Haas , Noah Misch , "pgsql-hackers@postgresql.org" Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. Message-ID: <20230707183059.GA3959628@nathanxps13> References: <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> <1130d49de6f6cb09714f702b7b01d0b7b471d370.camel@j-davis.com> <20230707165710.GA3855545@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230707165710.GA3855545@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 07, 2023 at 09:57:10AM -0700, Nathan Bossart wrote: > Yeah, I guess I should just revert it in both. Given your fix will > hopefully be committed soon, I was hoping to avoid reverting and > un-reverting in quick succession to prevent affecting git-blame too much. > > I found an example of a post-beta2 revert on both master and a stable > branch where Tom set the catversions to different values (20b6847, > e256312). I'll do the same here. reverted -- Nathan Bossart Amazon Web Services: https://aws.amazon.com