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 1ldsGv-00086R-9X for pgsql-hackers@arkaria.postgresql.org; Tue, 04 May 2021 10:27:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ldsGu-0007ps-2r for pgsql-hackers@arkaria.postgresql.org; Tue, 04 May 2021 10:27:20 +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 1ldsGt-0007pl-AE for pgsql-hackers@lists.postgresql.org; Tue, 04 May 2021 10:27:19 +0000 Received: from forward1-smtp.messagingengine.com ([66.111.4.223]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ldsGk-0001KM-Ku for pgsql-hackers@lists.postgresql.org; Tue, 04 May 2021 10:27:18 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailforward.nyi.internal (Postfix) with ESMTP id 6166F1940C17; Tue, 4 May 2021 06:27:07 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Tue, 04 May 2021 06:27:07 -0400 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=fm2; bh=eD2F8HhIakKSrmVwT6J4t3ePXsFqsmvUGdPCP91Mi 1g=; b=vbA4zlG0exCYr2i0RuYWYDMveC29/kZDFbLwMZckskcrToERKTXH1M7fB rd4abKVRnRddxtcj2lJVAZ6962jNH6qg7vTABwTHWLMytBq+rDK7oooyHDmSEmTO KBz37XeY8EwzkBL05mdVtuUs5RSxsJ7Y8D5zSsbt26MK2gA7KuG0ZFburhVpt/LX 8jb+4VjxJleGCLzzQ7INmQitt7H3iCOlws8dTv30wD9pX6InzkH1ljfIcpjDvSP8 DpOXnMG1mGi3M+xuApLWgmCTwU9XjqLXjZ4hAZzXPB7XpypfPg0hRD+SYxR7Nz13 XUMDIhMejrNRGpNpY99O/SlprrBRQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdefiedgfedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffhvfhfkffffgggjggtgfesthekredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvg hrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvghrnhepffefgeeljeettddviefg keekvefgleduveetgfehteefleetteejueehgeegudehnecukfhppeeluddrudegrddvvd egrdduvddtnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhho mhepphgvthgvrhdrvghishgvnhhtrhgruhhtsegvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Received: from laptop206oxuk.local (p5b0ee078.dip0.t-ipconnect.de [91.14.224.120]) by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 4 May 2021 06:27:05 -0400 (EDT) Subject: Re: Dumping/restoring fails on inherited generated column From: Peter Eisentraut To: PostgreSQL Hackers Cc: Tom Lane , Masahiko Sawada , Zhihong Yu , Masahiko Sawada References: <15830.1575468847@sss.pgh.pa.us> <3f272982-0e0d-17a1-3fb6-fedc74197676@2ndquadrant.com> <3169466.1594841366@sss.pgh.pa.us> <0f57d5e9-4112-1ba8-64d8-c02062c1e95d@postgrespro.ru> <41888c80-e5bd-f9e5-75dc-fb377113168c@2ndquadrant.com> <2808494.1611938475@sss.pgh.pa.us> <22de27f6-7096-8d96-4619-7b882932ca25@2ndquadrant.com> <0dbc982e-fbb3-911e-eb80-130494664940@2ndquadrant.com> Message-ID: <7d27c190-c065-6946-c9d4-0d3542959ee6@enterprisedb.com> Date: Tue, 4 May 2021 12:27:03 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0) Gecko/20100101 Thunderbird/78.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 26.04.21 14:10, Peter Eisentraut wrote: > On 05.02.21 15:18, Peter Eisentraut wrote: >> Anyway, I figured out how to take account of generation expressions >> with different column orders.  I used the same approach that we use >> for check constraints.  The attached patch is good to go from my >> perspective. > > Dusting this off ... this patch should go into the next minor releases. > The attached patch is for master but backpatches without manual > intervention to PG13 and PG12. committed