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 1knmzY-00075W-SU for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Dec 2020 18:18:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1knmzX-0005qG-Jo for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Dec 2020 18:18:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knmzW-0005pq-Kn for pgsql-hackers@lists.postgresql.org; Fri, 11 Dec 2020 18:18:07 +0000 Received: from wforward4-smtp.messagingengine.com ([64.147.123.34]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1knmzS-0000da-5Q for pgsql-hackers@lists.postgresql.org; Fri, 11 Dec 2020 18:18:05 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailforward.west.internal (Postfix) with ESMTP id E983D7EC; Fri, 11 Dec 2020 13:17:57 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Fri, 11 Dec 2020 13:17:58 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding: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=bvJByY16ABhEgnBY9xhQfeOJnQjV3yEczcW68iHxR Ss=; b=d19QRz0j9ZBHuXTeCHV1Vzt+EgX89Lo3j6baoHkhcKN/9YK1niFggaS3+ lu5VclcC8iRdmcmZtWQR7tK0GM82F/fV4ulbIJN7Na8hHDT6BmRNttT4ssGZZTh2 qMkHrBiasmyW7J4Mt2YaHJyR1dsjGLZsAZ3WcrU+VPNnaUqrYgBoaNdhXrHpqyx7 31kgHXUvxb0Fl3bP38d+/DmilR77BKOulMTmFZdRgqgXZ8ICaxl8K3mwVZIKpfdu 93CUvqVAskqlrNplz596H9ooIiMLA9LbAocni5ChVDlBXP6uerNOkcwiDxRQTNpJ SmXtn70IJWWTGQpyo12JVIAYyKJ+w== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudekvddgudduvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefheenucfhrhhomheprfgv thgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnh htvghrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepffdvueeftdfggfev ffdvheejkeejkeehvddvueehgefhffelvdfgffffffefjedunecukfhppeekjedrudejje drjedvrddugedvnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhf rhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvghrphhrihhsvggusgdrtg homh X-ME-Proxy: Received: from april.pezone.net (p57b1488e.dip0.t-ipconnect.de [87.177.72.142]) by mail.messagingengine.com (Postfix) with ESMTPA id 40EF324005A; Fri, 11 Dec 2020 13:17:50 -0500 (EST) Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly To: Michael Paquier , Alvaro Herrera References: <20201204192826.GA15417@alvherre.pgsql> Cc: Justin Pryzby , Alexey Kondratov , Masahiko Sawada , Steve Singer , pgsql-hackers@lists.postgresql.org, Robert Haas , Alexander Korotkov , Masahiko Sawada , Jose Luis Tallon From: Peter Eisentraut Organization: EnterpriseDB Message-ID: Date: Fri, 11 Dec 2020 19:17:48 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-12-05 02:30, Michael Paquier wrote: > On Fri, Dec 04, 2020 at 04:28:26PM -0300, Alvaro Herrera wrote: >> FWIW I'm with Peter on this. > > Okay, attached is a patch to adjust the enums for the set of utility > commands that is the set of things I have touched lately. Should that > be extended more? I have not done that as a lot of those structures > exist as such for a long time. I think this patch is good. I have in the meantime committed a similar patch for cleaning up this issue in pg_dump.