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 1kXdqx-0004sE-HV for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2020 05:18:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXdqw-0008Ac-Ft for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2020 05:18:30 +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 1kXdqw-0008AV-9k for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2020 05:18:30 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kXdqu-0008PK-BE for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2020 05:18:29 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id AD77FA93; Wed, 28 Oct 2020 01:18:26 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 28 Oct 2020 01:18:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=avZ5ljpQn0q2dMYGAtjYdiHL5U7 nke3pSeeNEzHXKHs=; b=s+pzVcHoBsVy2TNg6bi/I3/fiZnEXXXq33ePiUjIpam KF4Jf7UDrmTqyk8Wv/8C6uSuD9swxRqz//USTVs225eZNaS7+wcWKUoImsaA80DA wd2eB5vqBEPFYpUDUI72x7NG824Kwk3J3yKWmvXQUUOQiqhAjCPdqogIfTpkGWy+ tBdPFlKYD0ok3DwEMuGr7NQMiBKAqB52P+h8ZqdAv/i0Jz61ienTjFdLXno60Vpy vCWEQHPR6zKnhDZbhvPaIs6xM9LjNo8GMB+zRCQ74W1lLkDFkg5JOUQN67EoOvyU 46ycphRf7Zb9O3d55939R0yE4keT2Qz0qDWSU2L6bsQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=avZ5lj pQn0q2dMYGAtjYdiHL5U7nke3pSeeNEzHXKHs=; b=kS6IULO5x8v03zb878itZp mkJs6cmz1fdKhDwdaC+5b/KQZ0iJzaN4j7Aj/0pdKsGDxZcYzJA3RKX9g2HbUSyc mqTEbDKCEKKvcoWVBT4y0fd1vCWQbWXiynDeuO8VRNUiuY/W/8MvRaFxV4Rf7joc y/ams8gPIDwR8ICUm50CDwDi8iA7/QNdgLHC+B3ybcQQ7tCfNJdiGrOMQI55hXfo 30cP33XNATAUF5bRWmFBwnnxpZbNwChe4QvCAzc5qVtY+I0RWpUw2fO7OAUJd34f 7wYFFPzb3lj00/Pd2ksqvJUlIoMmrVjx/FIibt/K86ITXrylxs2L2yW07SHiNdxA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrledtgdektdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepvdegudeuhfdtueeltedtveejheeh ieevueeigeelteegleejleeiueeiheegvefhnecukfhppeduuddurddutddvrddukedtrd dukeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhep mhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 886E33280059; Wed, 28 Oct 2020 01:18:24 -0400 (EDT) Date: Wed, 28 Oct 2020 14:18:21 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Tomas Vondra , Tom Lane , exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16577: Segfault on altering a table located in a dropped tablespace Message-ID: <20201028051821.GI28445@paquier.xyz> References: <20200908235553.7tbd6xjvnohv2xel@development> <20201015151959.GA6823@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="iSeZnk6FyAS3EJ1y" Content-Disposition: inline In-Reply-To: <20201015151959.GA6823@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --iSeZnk6FyAS3EJ1y Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Oct 15, 2020 at 12:19:59PM -0300, Alvaro Herrera wrote: > It just dawned on me that a way to fix this is to use a pg_shdepend > entry to protect the tablespace from being dropped. Haven't thought of that approach, good idea! That would not be backpatchable but that would be a solution that does not require creating files where we don't need them. Did you begin to look at that? -- Michael --iSeZnk6FyAS3EJ1y Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl+Y/x0ACgkQnvQgOdby QH0YSQ/9GQQ1M3dn3j1qBnC/bNjYq/VXALU4KLUztBLAQCTehrJbU9LnwqAl79UB EBmEluyZzhYH1F497GFwKV/jQ0cpmC0/LVw576K38zD/ePH0aW3p0uZypEycMIX+ K4/zlAeKyZsqjcoat5F/8ZqlFNH4PIDtzAhg5RN9s0g4X3O/2lgAGeLIkCyEdsul tHQw1E/5FLCdAzDXODshK5fIzk1zIlgnjcC8ArOS3nO7sp7UH/Oj41FAnhtBgY5F kstsx5u9U7pR+zxyDDTUgjOlMTALJeM3r390rh9fvItG4oTYFkhf6Vhp05urAl+w aESEVwCObKTLz9SU1whdRAzdg79Wypdo+74G9pkliRJTVs7xYd4SOBlExaR8hXaG /g5PaH6hKs4Hcj8mOTkI1LgFOlbu4S2eN649/Lw+Dxg6uRJlduER64eoJfNmW8w7 pyztGUalHIOgF7/pJ7LrLqX5i1/hYoMvDELTvwv1y35bHtw5gkspTBG2jGOhU+NI owtRKuJMWmkpAGBtkRseB1e8a4yf4iMAZeXStITtqI15r0WbaFCSLH1NeMHnW6+M i/Zt2DvKGUqK2Kc1z9873p7ev+7Nkv0LTQtlLFVTRZXQAHEeXcs5odKbRtMP2XcD OgmmAllb1A2JViE03OB70KeXHxmlWO+9CopcCJprCtKjfpTniMI= =LbaP -----END PGP SIGNATURE----- --iSeZnk6FyAS3EJ1y--