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 1rhKSK-00AscS-Us for pgsql-committers@arkaria.postgresql.org; Tue, 05 Mar 2024 02:23:01 +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 1rhKSJ-00CVGp-HA for pgsql-committers@arkaria.postgresql.org; Tue, 05 Mar 2024 02:23:00 +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 1rhKSJ-00CVGg-6G for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 02:22:59 +0000 Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rhKSF-002tSQ-VL for pgsql-committers@lists.postgresql.org; Tue, 05 Mar 2024 02:22:58 +0000 Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-22008177fbeso3186110fac.2 for ; Mon, 04 Mar 2024 18:22:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1709605376; x=1710210176; darn=lists.postgresql.org; 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=Zi7VVGBXE9KMZaDcBfnhRxncg14zCHdJP4jynp9bb7o=; b=ZdvtHsyhx0IUKDmjaknrTXvkfByerntZQmzPb7yCB9HejXmij6Iz/aktPLx3Q+j78l ijhGgyQi+U+X9LcMCU6H+3SCo/rx6KuYXu52OYzs4dZT46gDliIxfETpUbwIDTZ5FNLl eeRbz/dhyo1jVtg1Fos6cJ9kbju9DoblHvGYqLjYfTEjOw0j7qeIsA0b/b9uyFeMGyDe yCs710RgWTtcbZIfAx0ehxXWl2tmeJQpR2T3l3ldvLoDRO3mVATxN4jOwRSXCux8A3AV zS+HsuOaev2vls5Or0UdHJGo2ji19ef08zB2h0gUyXRoVlEIAX7DWxVtn/egaL2aBOZn 8pXA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709605376; x=1710210176; 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=Zi7VVGBXE9KMZaDcBfnhRxncg14zCHdJP4jynp9bb7o=; b=u7StfSmcGGJlkZcPMv7DMP417bNqdyvU0WJxgG6prDy1C0ZVcoRpIoV2ovdH4tMsvT j6zdnqI9kGYEKLgHgWnwyvmtRYYVqm7hwH3BksPn4Cx+mrdRdDSwuy+eaDmO+FFCLwvV C6pzWP0TGF6tfnCSpnx1XITwxIi72ay57fw05kuWzTKK8QR7dm3tUTQ2X6wU1+8lfISs I8+gVQUPdwHwMVwx8HmYXR4sh1/aF3R16UCFyDi+vJIr9A5euG6697t0qcxlfpDbaZ1Z LcgM5tb64YECMj6AdY/caU91QBKhiFvcdLInz9/zOp5gtph05xJoxhQIDu2U362FYlP8 uavw== X-Gm-Message-State: AOJu0Yz24HpNtgA2hsAyOjZBCBfdfs6JzP6tisYsTth/2+uRSDH5rwth iqv0nZyVxjbRGaYFiLyFh9uvmazhO8SOWIg6A4sb1Nhv/xic6iL5xUKGg1BO3A== X-Google-Smtp-Source: AGHT+IH3SsN5fK0ofM5IQUNrJgiq/y3HSMjA73GnKdV6y2IONls8FqTr7HSLzoj+7SiS3f+H6JY7eg== X-Received: by 2002:a05:6871:538a:b0:21f:ca8c:d7d9 with SMTP id hy10-20020a056871538a00b0021fca8cd7d9mr594070oac.3.1709605376329; Mon, 04 Mar 2024 18:22:56 -0800 (PST) Received: from [172.18.10.46] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id z1-20020a62d101000000b006e5db93342asm5170539pfg.208.2024.03.04.18.22.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 04 Mar 2024 18:22:55 -0800 (PST) Message-ID: Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations. From: Jeff Davis To: Tom Lane , Jeff Davis Cc: pgsql-committers@lists.postgresql.org Date: Mon, 04 Mar 2024 18:22:55 -0800 In-Reply-To: <3926516.1709604927@sss.pgh.pa.us> References: <3926516.1709604927@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2024-03-04 at 21:15 -0500, Tom Lane wrote: > Jeff Davis writes: > > Fix search_path to a safe value during maintenance operations. >=20 > The buildfarm seems pretty unhappy with this. Looks like I need to use GUC_ACTION_SAVE. I will remedy it shortly. Regards, Jeff Davis