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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1rhZ7A-00CADf-RC
	for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Mar 2024 18:02:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1rhZ78-001Nec-RF
	for pgsql-hackers@arkaria.postgresql.org; Tue, 05 Mar 2024 18:02:07 +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 <pgsql@j-davis.com>)
	id 1rhZ78-001NeU-5D
	for pgsql-hackers@lists.postgresql.org; Tue, 05 Mar 2024 18:02:06 +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 <pgsql@j-davis.com>)
	id 1rhZ74-0030U5-4k
	for pgsql-hackers@lists.postgresql.org; Tue, 05 Mar 2024 18:02:05 +0000
Received: by mail-pl1-x62b.google.com with SMTP id
 d9443c01a7336-1dbd32cff0bso50969485ad.0
        for <pgsql-hackers@lists.postgresql.org>;
 Tue, 05 Mar 2024 10:02:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1709661722;
 x=1710266522; 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=/+yFd4OiN2lrQ3Yl4VnaONJ4IYUulAbuonP1ezXvd+w=;
        b=mM/OZMv5tp5WtS5pPcRg8QTRZMYQpv1Lv0S4sJLsewR36PXobuHFjwySiabRO9g0f7
         9/Rd1l3YG5raW8oTArUwLvwbSS9ni4lFF3SaioYQpYmh9GaPPDVXpIKKsQ+l1wz7xcrP
         R682SyqhdRZj1L4f1AiQLYqOj2ni4aTKkpWXknfEz8yLSw6GfF7O7PygZNdPGwofx7aM
         DQkG9z+xdt88GYoUJw7rLRwBsZ9KIeicfJVeIj5hd97+W4y7Mh746kOVpRDnkRtoNwGT
         ZuwgFK7Lcy5GWwIGEUt5XsZSCR+Eh94BtkqkCs8IZX5DFCx4aMy6uEbbOwEpQ2dpBlWN
         R2HA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1709661722; x=1710266522;
        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=/+yFd4OiN2lrQ3Yl4VnaONJ4IYUulAbuonP1ezXvd+w=;
        b=MrfuoFMracBpiyc+LqRENSgFoKylCuZ0DcNkZoypQdgPV7M/rqbLxp0hpjsucwjdgj
         2PNRnPZMGJVbgDTURLj4aCQSFcMyZM8hfzVjIbDoBWg6RiDn/8WgfyexB60hkrdKwAt/
         1wS+RZp2A/Gc0hJaPtCqq6sIatYrNjesAjZ0U4qxdQpnszyCDcxMFMZLeiXR17MsjHHQ
         ZxoYHQXMpfvE6kzdJZL/JvGE0PinjbmmcaVVFqUoTNNzoxombV/X/gTzzkVpQ8odu90r
         er7nVr2Eo6KKP8F2FlcuonkRB/2ZZzQ5KbdADF9OtiOcw3ap0Q2HOGJOwgh+sOptMqKC
         V7dg==
X-Gm-Message-State: AOJu0Yw6u2vDb+Pp5+hYFGdlJNV48fWNuP2ClOfVgfU92OacIYDq7NfL
	ym4WL7bGYJRTEyq1gga0PAWRQHiQzGqjzoPiAAuYW5fli3ogR9bEBPirkZhi6Q==
X-Google-Smtp-Source: 
 AGHT+IHHEfmtdRk4ORUH0TasIOawLQOAAW2NI6vFixNj2/03bt+gyo+wpSFJ8jbNvha3QComs+GZrg==
X-Received: by 2002:a17:903:22d1:b0:1dc:1c81:1b17 with SMTP id
 y17-20020a17090322d100b001dc1c811b17mr2669051plg.55.1709661722243;
        Tue, 05 Mar 2024 10:02:02 -0800 (PST)
Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net.
 [76.102.242.158])
        by smtp.gmail.com with ESMTPSA id
 u12-20020a170902b28c00b001dc94fde843sm10835181plr.177.2024.03.05.10.02.01
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Tue, 05 Mar 2024 10:02:01 -0800 (PST)
Message-ID: <9ef5d36a997aea44eae8efb8cda4893117e87f95.camel@j-davis.com>
Subject: Re: pgsql: Fix search_path to a safe value during maintenance
 operations.
From: Jeff Davis <pgsql@j-davis.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>, Jeff Davis
 <jdavis@postgresql.org>
Cc: pgsql-hackers@lists.postgresql.org
Date: Tue, 05 Mar 2024 10:02:00 -0800
In-Reply-To: <202403051619.jiuwd3ec4jmi@alvherre.pgsql>
References: <202403051619.jiuwd3ec4jmi@alvherre.pgsql>
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: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/9ef5d36a997aea44eae8efb8cda4893117e87f95.camel%40j-davis.com>
Precedence: bulk

On Tue, 2024-03-05 at 17:19 +0100, Alvaro Herrera wrote:
> This appears to have upset the sepgsql tests.=C2=A0 In buildfarm member
> rhinoceros there's now a bunch of errors like this

Thank you, pushed, and it appears to have fixed the problem.

Regards,
	Jeff Davis