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 1qT9X5-008ahy-IA for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Aug 2023 23:21:04 +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 1qT9X3-00CCVq-5S for pgsql-bugs@arkaria.postgresql.org; Mon, 07 Aug 2023 23:21:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qT9X2-00CCVi-DC for pgsql-bugs@lists.postgresql.org; Mon, 07 Aug 2023 23:21:01 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qT9Wz-001BFd-Hv for pgsql-bugs@postgresql.org; Mon, 07 Aug 2023 23:21:00 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id 578F4320025E; Mon, 7 Aug 2023 19:20:54 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Mon, 07 Aug 2023 19:20:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1691450453; x=1691536853; bh=FK oiPYJ6YJBaIADuWj9OV/DiG2MSbSaK6101Z9/MClQ=; b=SjFMzrTB2Kb4u2mdoQ jNcTzFuY2iAOUOuW0/H+nPN4EAP+pDud+T0b3BheKg/ixHLFc3HrfxgAv4kaojd5 tWIj8XcZZ0DYTqsVRfYflP2zcG8tRqJtTZR5y5gFIF/eHom29o6rgKMU9i16o+z+ GaH+a1lrTP39Xd4bugDTbjunBWXIfvarYufQVtuiZGjnsV4v1cySIuiTNeysr3wH PsuWhHnrrARinxnTfgB2otJgjvYCtHnC4sWMXKpcGzAAmq0wT0sYJchP8T0s3TLc rdwikkIHUW+EPfmgiACEodG1NupwTQhDfUB0YhKoK6nbgGq676hmvfF2aMOQkNI8 0/uQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1691450453; x=1691536853; bh=FKoiPYJ6YJBaI ADuWj9OV/DiG2MSbSaK6101Z9/MClQ=; b=RnlKub2g4Ne9KLwCwGbqgVaQks7f/ VpArl6MeyvrSaLTf2ahwSwX4EU9RXQshDnLLznQ84LnQBu5K6zwFYVlfTYw2N1QT FEvXUvHLA3gVasvwUQYqJsZgIx4WaqDRQN8uwaOcx2DHYqhCs5neXhBMYdagTFjh gCqBYi6Q4iSqG5WtIWUxi53UDDHaoPRPGCw9zKLggNkvIKx9QT8J0STC/wy/mQwV g3jVCxsAJiEkIroDHIWoqeoIMdC5saQjzs+NX9ehxz50NkXY5g6jG7r0slPp6JT6 WahkiMEQTUd7NNRAi216MTHn6q0wRYKTxeygzOMMBf4WsRMnyRPg3bTZg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrledugddulecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 7 Aug 2023 19:20:51 -0400 (EDT) Date: Tue, 8 Aug 2023 08:20:48 +0900 From: Michael Paquier To: Nathan Bossart Cc: Jeff Davis , pgsql-bugs@postgresql.org Subject: Re: search_path not recomputed when role name changes Message-ID: References: <186761d32c0255debbdf50b6310b581b9c973e6c.camel@j-davis.com> <20230730040802.GA284134@nathanxps13> <628b8fcc7b99bb06717a569cc91fb6436e499139.camel@j-davis.com> <20230803232841.GA1238296@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="hsITOmV/HaFFqR5Y" Content-Disposition: inline In-Reply-To: <20230803232841.GA1238296@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --hsITOmV/HaFFqR5Y Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Aug 03, 2023 at 04:28:41PM -0700, Nathan Bossart wrote: > It looks like folks try to group related tests, but I don't sense any > strict ordering. It's probably fine to add it to the end. Maybe we should > alphabetize the list someday (/me braces for collation jokes). Isolation tests have been added over the years in the order that a committer and/or author saw fit at the point when it was added. There has never been any kind of strict ordering, but there may be locations where having a new test makes more sense than other locations. -- Michael --hsITOmV/HaFFqR5Y Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmTRfFAACgkQnvQgOdby QH03YxAAi/uUYVa+SDNeA26DFG1Z8lO0edZjX9cisUB10UpcEVcekpnQ3pxfSCRb h342IqLVzu0ePWOsT/UynTpzLXB1dWezIch4RMSiN4qDwvO0i96c3V3Rg99MyWhE 5AAwS2tlRAYyd+XrWKD5dBv9cGkuyZOyh6xQaiLelqQF5xemfM3o4sVZJ43DA+hZ xkFC9jZKz5UGjegUuWKebxvQvIQQsDKV3YFMeDHJoQxcj/g6r5+OKbFx8orw5Zda JuiA+SeGbcGGG2+QD6xyroktZmjcwYS1D6Lr3NqubQGJuB+Otd8vjsTzBIzQ6/Nb OvX+c8toyypU/c79ElwQ3sygjzXCI2wLP3phsin3GNjUT/nfbDPS8MGuVqrfE+fq TcG5qNEyszfpklL5R2vQaSJy7aveYO6ViKkJzup8FjJ8dmKZCnGWxKNl9DXh8cPn D2ycIHZ6pvTQ0poy7/0/v/o3bPqE+OuaVVGbBV1zM53CLsZpCUVEwa///26+nVh7 VZk+hNdTTbKd3OHaHFRwMUDB/Oz7QNe8wG7p7InQS4jgLOjfPmpflKAt2s9O2rmt F4hcV6f7eDCZ3l5w9HU1NZR0KfLqB/wKSPs8N9r4E+Tv7a4J/XyQqQFF/hpoAFh7 rlZS+GTZRqTuSLOqq+MWOOdPs5auFau4Qe9McTxk6IcxJIA8ctw= =yKYo -----END PGP SIGNATURE----- --hsITOmV/HaFFqR5Y--