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 1srBr7-00FzVE-Hs for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Sep 2024 07:45:37 +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 1srBr5-0064Q8-5I for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Sep 2024 07:45:35 +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 1srBr4-0064Q0-TJ for pgsql-bugs@lists.postgresql.org; Thu, 19 Sep 2024 07:45:34 +0000 Received: from fout7-smtp.messagingengine.com ([103.168.172.150]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srBqy-001w4b-Ex for pgsql-bugs@lists.postgresql.org; Thu, 19 Sep 2024 07:45:33 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfout.phl.internal (Postfix) with ESMTP id 738251380204; Thu, 19 Sep 2024 03:45:27 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Thu, 19 Sep 2024 03:45:27 -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:subject :subject:to:to; s=fm2; t=1726731927; x=1726818327; bh=6s4mZOlfKp mxUjJ+O8f3ih+nUGAHS5beQQvN9zyGrqs=; b=dVPd4ZCXf6sbLHr1boG5BFYKR4 /wkd7IeXPmUVgKdWv/qWD5kaQKvpJuMYaspNDavXbunTHsb03nbkGVgbEiBXzPal T39PL13TZwZwhQK4zGMirSgrJMgS2jk6MLfzdsg790Sne3EyCf/uJEp5zfrva6M6 8RwuT/VnD/f6nq2Th6/4NwqK3SQqEpXvxIPLC7vRj2BYoDsdJqToHD2UdDckwDnC 1RaHFMYJc1yjJv6C7WtrIUm6iZzQgxCJa2vG0jJtyPHd1B4xMzTyYZo053LlQUr7 bX9grDai1bhFelrTBTfsTMUo3MwgOnh4mRgl0WR18ekFVCRJTG8sMHNNU0Xg== 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:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1726731927; x=1726818327; bh=6s4mZOlfKpmxUjJ+O8f3ih+nUGAH S5beQQvN9zyGrqs=; b=YiJFGTBGl+K3aIJ0f9rlOWd26GqaYvlkrR7CgXnlZkoD 9SG26/s+QGiqHtFkmBWXlaqMu1MGRP5FzGsUKqrNJZ0P1ZSUoPupQICeQQcw6loa 5QgMQb73dZo9C/dbyRwqKs2ExHZ97I9zJYzeKoUOCl5eTseqjmjZdTobVcir5k3m scRivmV2lKezcLhP3IbUkltS4dHzkVrIVd58vViD7OWq2mtRuMLBdXJcUORqda7j AHyujBsDPkFECLcxGaAtt/7yDYbTcg2oqwrhw3NotqHorg/D/bdMpucthPLnau82 Qd8GmXEXazLjQVWZWYsqgbkz9ZnxMmHdQ40SvOq3/g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudeltddguddvjecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffk fhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrh cuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeet leeifedufffhhfdtteelgeeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghl sehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegurghnihgvlheshigvshhqlhdrshgvpdhrtghpthhtohepnhdr khgrlhhinhhinhesphhoshhtghhrvghsphhrohdrrhhupdhrtghpthhtohepphhgshhqlh dqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 19 Sep 2024 03:45:24 -0400 (EDT) Date: Thu, 19 Sep 2024 16:44:58 +0900 From: Michael Paquier To: Daniel Gustafsson Cc: n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role Message-ID: References: <18609-4f426b9a2809baa8@postgresql.org> <61043C0D-A79D-457A-AC2A-4719D036FBCD@yesql.se> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="73QUUpLaGFoCL8fv" Content-Disposition: inline In-Reply-To: <61043C0D-A79D-457A-AC2A-4719D036FBCD@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --73QUUpLaGFoCL8fv Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Sep 11, 2024 at 10:01:22AM +0200, Daniel Gustafsson wrote: > That would be backpatching 936e3fa3787a51397280c1081587586e83c20399. I haven't > checked if there are complications in doing so but I think it should be quite > straightforward. As far as I can see it would be enough to add the DROP OWNED BY to avoid the random notice messages listing the dependencies the role depends on, followed by the DROP ROLE. FWIW, I am not seeing any complications (the TAP test recreates the same role name regress_dump_test_role on its own), so let's just do it. -- Michael --73QUUpLaGFoCL8fv Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmbr1noACgkQnvQgOdby QH3bxRAAhxql+PTvIJh5JuUpE9k6BrCBjr82i287JmhulN+UH/vE7WcoSG6cbIux UXNi7pJSHuuQrVkm9d05b6/nYXBbwCluFTdFRJQljOISkOuaYVE6TMRAe6ExE3bh rBzM4s0stusRrTcCe09VgIlwP+F/OXiittFhPZxbuYBLj9m5LqUgqWbfWhXI35rZ eQpQnUiCjkcB4GHcmwuhlIV55e84IizXVgjmsV8l5HFSHR/JSvAG5tgZtqEHtvQ2 ixUI661CIKbMKdJniq1e9RwUwn0TmPrw+FtZ5zjRsIBKPlTo3zclI6RFrr6wgUBt zPMteV6Am2JkIhGnpAvn3ShRAkPOaCIQ3n2WOXpSHoXaVlqnTEQA7ChM66G9tl5m iYHnpP3VqxZabDb4D7PIJQjPlgt8BQ1kz7ZxHR+aD+VVb1ga639LSnoheP+IqJfd K2F1A1FXSaLZEQIZ6pqosY5GYn4kmmQ7hXnqk0XP19HmPNchIEk1xEeY7OiLQ7pE 5n5isIzRm7jhDrzel3X2AtmolVglKwRhMiRGI6SQ5ZIJezM98I9W2XtCNbjKfWW9 R/BVYwRSUwgEbPT/w9vLdx3vAFoNJM9GOFJf/oLDW/zcLZsW20QhDJzTu6L6pCUI bA9g+e2c+t2DyX1g05qyGf/hJWV+XzZa3F+4rXGVze6vxiBOEKs= =frt7 -----END PGP SIGNATURE----- --73QUUpLaGFoCL8fv--