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 1lmCD6-0005ZO-Uh for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 09:21:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmCD5-0004Hy-9m for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 09:21:47 +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 1lmCD4-0004F5-JS for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 09:21:47 +0000 Received: from m1546.mail.126.com ([220.181.15.46]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmCCy-0002GI-Kk for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 09:21:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:MIME-Version:Message-ID; bh=TI2pW igEDZ6ZgrXPXrwsowS8d+b5GNERxNmnhS0zVcE=; b=KLuumjUx6qHxszgmCkAaf xXGwYu2TaRQOWR1Uwgy9LWBPkgPNTabGLD49zBcAQdY9/YfaI10fJX/UEk1syPay vBBe5qfzMbituY1qKOHJfEia6GvKunqlAT9AxqReMEg4POpp/Zgfoh3xnAopnxql VJyAJZ8ZOV0g2CtpkvOmSI= Received: from digoal$126.com ( [42.120.75.254] ) by ajax-webmail-wmsvr46 (Coremail) ; Thu, 27 May 2021 17:21:34 +0800 (CST) X-Originating-IP: [42.120.75.254] Date: Thu, 27 May 2021 17:21:34 +0800 (CST) From: =?GBK?B?tcK45w==?= To: "David G. Johnston" Cc: "pgsql-bugs@lists.postgresql.org" Subject: Re:Re: BUG #17036: generated column cann't modifyed auto when update X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.13 build 20210104(ab8c30b6) Copyright (c) 2002-2021 www.mailtech.cn 126com In-Reply-To: References: <17036-e4d41f4221873a17@postgresql.org> <23824c32.12e8.179ab97fa8a.Coremail.digoal@126.com> <2e46e6b5.1930.179abb8b6c0.Coremail.digoal@126.com> Content-Type: multipart/alternative; boundary="----=_Part_71803_1940473784.1622107294458" MIME-Version: 1.0 Message-ID: X-Coremail-Locale: zh_CN X-CM-TRANSID: LsqowAA3jgWfZK9gRx1XAQ--.11755W X-CM-SenderInfo: 5glj0tbo6rjloofrz/1tbiuwWfl1pEEI--ogABsr X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_71803_1940473784.1622107294458 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SEksCgoKVXNpbmcgdHJpZ2dlciBpcyBhIGdvb2Qgc3VnZ2VzdGlvbiwgd2UnbGwgdXNlIHRyaWdn ZXIgbmV4dCwgYnV0IEkgd2FudCB0byB0YWxrIGFib3V0IHdoZXRoZXIgdGhpcyBwaGVub21lbm9u IGlzIGFibm9ybWFsLgpJZiB0aGUgdmFsdWUgb2YgdGhlIGltbXV0YWJsZSBmdW5jdGlvbiBjaGFu Z2VzLCB0aGUgaW1tdXRhYmxlIGZ1bmN0aW9uIHNob3VsZCBiZSByZWNhbGN1bGF0ZWQuCkZvciBl eGFtcGxlLCBJIGhhdmUgYWxyZWFkeSBkZW1vbnN0cmF0ZWQgdGhpczoKYCBgIGAKcG9zdGdyZXM9 IyBjcmVhdGUgb3IgcmVwbGFjZSBmdW5jdGlvbiBpbV9ub3cgKGZsb2F0OCBkZWZhdWx0IHJhbmRv bSgpKSByZXR1cm5zIHRpbWVzdGFtcHR6IGFzICQkCgoKcG9zdGdyZXMkIyAgIHNlbGVjdCBub3co KTsKCgpwb3N0Z3JlcyQjICQkIGxhbmd1YWdlIHNxbCBzdHJpY3QgaW1tdXRhYmxlOwoKCkNSRUFU RSBGVU5DVElPTgoKCnBvc3RncmVzPSMKCgpwb3N0Z3Jlcz0jIGNyZWF0ZSB0YWJsZSB0MSAoaWQg aW50IHByaW1hcnkga2V5LCBjMSBpbnQsIGluZm8gdGV4dCwgY3J0X3RpbWUgdGltZXN0YW1wLAoK CnBvc3RncmVzKCMgbW9kX3RpbWUgdGltZXN0YW1wIEdFTkVSQVRFRCBBTFdBWVMgQVMgKGltX25v dygpKSBzdG9yZWQpOwoKCkNSRUFURSBUQUJMRQpgIGAgYAoyLiBIb3cgdG8gZXhwbGFpbiB0aGlz IHBoZW5vbWVub24/IEl0IGRvZXNuJ3Qgc2VlbSB0byBoYXZlIGJlZW4gcmUtaW1wbGVtZW50ZWQh IE9LLCBJIGJlbGlldmUgdGhpcyBpcyBhIGJ1Zy4gSW4gYWRkaXRpb24gdG8gbGltaXRpbmcgdGhl IGdlbmVyYXRlZCBjb2x1bW4gZXhwcmVzc2lvbiB0byBiZSBpbW11dGFibGUgaXRzZWxmLCB3ZSBz aG91bGQgYWxzbyByZXN0cmljdCB0aGUgZGVmYXVsdCB2YWx1ZSBvZiB0aGUgcGFyYW1ldGVyIHRv IHRoZSBmdW5jdGlvbiB0byBiZSBpbW11dGFibGUuCgoKYmVzdCByZWdhcmRzLApkaWdvYWwKCgoK CgoKCgoKCgoKCi0tCgq5q9LmysfSu7Gy19O1xMrCLEknbSBEaWdvYWwsSnVzdCBEbyBJdC4KCgoK CgrU2iAyMDIxLTA1LTI3IDExOjE2OjEwo6wiRGF2aWQgRy4gSm9obnN0b24iIDxkYXZpZC5nLmpv aG5zdG9uQGdtYWlsLmNvbT4g0LS1wKO6CgpPbiBXZWRuZXNkYXksIE1heSAyNiwgMjAyMSwgtcK4 5yA8ZGlnb2FsQDEyNi5jb20+IHdyb3RlOgoKCgpUaGUgZ2VuZXJhdGVkIGNvbHVtbiBjYW4gYmUg dXNlZCB0byBhdXRvbWF0aWNhbGx5IGdlbmVyYXRlIHRoZSBtb2RpZmllZCB0aW1lc3RhbXAgb2Yg YSB0dXBsZSwgYnV0IFBHIDEyIGN1cnJlbnRseSBzdXBwb3J0cyB0aGlzIHNjZW5hcmlvLiBQRyAx MyBoYXMgc3RhcnRlZCB0byBjaGFuZ2UgaXRzIGJlaGF2aW9yLCB3aGljaCBtYWtlcyBvdXIgYXBw bGljYXRpb24gbmVlZCB0byBiZSBtb2RpZmllZC4gVGhpcyBpcyB0aGUgZmlyc3QgdGltZSBJIGhh dmUgZXZlciBzZWVuIGEgUEcgdXBncmFkZSBraWxsIGEgbmljZSBmZWF0dXJlLgoKCgoKCgpJdCB3 YXMgbmV2ZXIgYSBmZWF0dXJlIGluIHRoZSBmaXJzdCBwbGFjZSBzbyBub3RoaW5nIGhhcyBiZWVu IGtpbGxlZC4gIFRoZSBkb2N1bWVudGF0aW9uIHNheXMgdGhlIGZ1bmN0aW9uIG11c3QgYmUgaW1t dXRhYmxlLiAgWW91ciBmdW5jdGlvbiBpcyBub3QuICBZb3Ugc2hvdWxkIGhhdmUgdXNlZCBhIHRy aWdnZXIsIGFuZCB0aGUgZmFjdCB5b3UgaGFkIHRvIHdyaXRlIGEgd3JhcHBlciBmdW5jdGlvbiB0 byBoYWNrIHRoZSB2b2xhdGlsaXR5IG1lYW5zIHRoYXQsIGZyYW5rbHksIGl0cyB5b3VyIGRpc3Jl Z2FyZCBmb3IgYSBrbm93biBsaW1pdGF0aW9uIHRoYXQgaGFzIHByb2R1Y2VkIHRoaXMgbmVlZCB0 byBjaGFuZ2UgeW91ciBhcHBsaWNhdGlvbiB3aXRoIHRoZSByZWxlYXNlIG9mIGEgbmV3IG1ham9y IHZlcnNpb24gLSBub3QgYW55IGJ1ZyBvciBkZWNpc2lvbiBvbiB0aGUgcGFydCBvZiBQb3N0Z3Jl U1FMLgoKCkRhdmlkIEou ------=_Part_71803_1940473784.1622107294458 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPkhJLDwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48ZGl2 IHN0eWxlPSJtYXJnaW46IDA7Ij5Vc2luZyB0cmlnZ2VyIGlzIGEgZ29vZCBzdWdnZXN0aW9uLCB3 ZSdsbCB1c2UgdHJpZ2dlciBuZXh0LCBidXQgSSB3YW50IHRvIHRhbGsgYWJvdXQgd2hldGhlciB0 aGlzIHBoZW5vbWVub24gaXMgYWJub3JtYWwuPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+ SWYgdGhlIHZhbHVlIG9mIHRoZSBpbW11dGFibGUgZnVuY3Rpb24gY2hhbmdlcywgdGhlIGltbXV0 YWJsZSBmdW5jdGlvbiBzaG91bGQgYmUgcmVjYWxjdWxhdGVkLjwvZGl2PjxkaXYgc3R5bGU9Im1h cmdpbjogMDsiPkZvciBleGFtcGxlLCBJIGhhdmUgYWxyZWFkeSBkZW1vbnN0cmF0ZWQgdGhpczo8 L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5gIGAgYDwvZGl2PjxkaXYgc3R5bGU9Im1hcmdp bjogMDsiPnBvc3RncmVzPSMgY3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24gaW1fbm93IChmbG9h dDggZGVmYXVsdCByYW5kb20oKSkgcmV0dXJucyB0aW1lc3RhbXB0eiBhcyAkJDwvZGl2PjxkaXYg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5wb3N0 Z3JlcyQjJm5ic3A7ICZuYnNwO3NlbGVjdCBub3coKTs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46 IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+cG9zdGdyZXMkIyAkJCBsYW5n dWFnZSBzcWwgc3RyaWN0IGltbXV0YWJsZTs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48 YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+Q1JFQVRFIEZVTkNUSU9OPC9kaXY+PGRp diBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPnBv c3RncmVzPSM8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHls ZT0ibWFyZ2luOiAwOyI+cG9zdGdyZXM9IyBjcmVhdGUgdGFibGUgdDEgKGlkIGludCBwcmltYXJ5 IGtleSwgYzEgaW50LCBpbmZvIHRleHQsIGNydF90aW1lIHRpbWVzdGFtcCw8L2Rpdj48ZGl2IHN0 eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+cG9zdGdy ZXMoIyBtb2RfdGltZSB0aW1lc3RhbXAgR0VORVJBVEVEIEFMV0FZUyBBUyAoaW1fbm93KCkpIHN0 b3JlZCk7PC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9 Im1hcmdpbjogMDsiPkNSRUFURSBUQUJMRTwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPmAg YCBgPC9kaXY+PGRpdiBzdHlsZT0ibWFyZ2luOiAwOyI+Mi4gSG93IHRvIGV4cGxhaW4gdGhpcyBw aGVub21lbm9uPyBJdCBkb2Vzbid0IHNlZW0gdG8gaGF2ZSBiZWVuIHJlLWltcGxlbWVudGVkISBP SywgSSBiZWxpZXZlIHRoaXMgaXMgYSBidWcuIEluIGFkZGl0aW9uIHRvIGxpbWl0aW5nIHRoZSBn ZW5lcmF0ZWQgY29sdW1uIGV4cHJlc3Npb24gdG8gYmUgaW1tdXRhYmxlIGl0c2VsZiwgd2Ugc2hv dWxkIGFsc28gcmVzdHJpY3QgdGhlIGRlZmF1bHQgdmFsdWUgb2YgdGhlIHBhcmFtZXRlciB0byB0 aGUgZnVuY3Rpb24gdG8gYmUgaW1tdXRhYmxlLjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsi Pjxicj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij5iZXN0IHJlZ2FyZHMsPC9kaXY+PGRp diBzdHlsZT0ibWFyZ2luOiAwOyI+ZGlnb2FsPC9kaXY+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjog MDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdp bjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PGRpdiBzdHlsZT0i cG9zaXRpb246cmVsYXRpdmU7em9vbToxIj48cCBzdHlsZT0ibWFyZ2luOiAwIj4tLTwvcD65q9Lm ysfSu7Gy19O1xMrCLEknbSBEaWdvYWwsSnVzdCBEbyBJdC48YnI+PGRpdiBzdHlsZT0iY2xlYXI6 Ym90aCI+PC9kaXY+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48L2Rpdj48cCBz dHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cD7U2iAyMDIxLTA1LTI3IDExOjE2OjEwo6wiRGF2 aWQgRy4gSm9obnN0b24iICZsdDtkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbSZndDsg0LS1wKO6 PC9wPjxibG9ja3F1b3RlIGlkPSJpc1JlcGx5Q29udGVudCIgc3R5bGU9IlBBRERJTkctTEVGVDog MWV4OyBNQVJHSU46IDBweCAwcHggMHB4IDAuOGV4OyBCT1JERVItTEVGVDogI2NjYyAxcHggc29s aWQiPk9uIFdlZG5lc2RheSwgTWF5IDI2LCAyMDIxLCC1wrjnICZsdDs8YSBocmVmPSJtYWlsdG86 ZGlnb2FsQDEyNi5jb20iPmRpZ29hbEAxMjYuY29tPC9hPiZndDsgd3JvdGU6PGJyPjxibG9ja3F1 b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1s ZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgc3R5bGU9ImxpbmUtaGVp Z2h0OjEuNztjb2xvcjojMDAwMDAwO2ZvbnQtc2l6ZToxNHB4O2ZvbnQtZmFtaWx5OkFyaWFsIj48 ZGl2IHN0eWxlPSJtYXJnaW46MCI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowIj5UaGUg Z2VuZXJhdGVkIGNvbHVtbiBjYW4gYmUgdXNlZCB0byBhdXRvbWF0aWNhbGx5IGdlbmVyYXRlIHRo ZSBtb2RpZmllZCB0aW1lc3RhbXAgb2YgYSB0dXBsZSwgYnV0IFBHIDEyIGN1cnJlbnRseSBzdXBw b3J0cyB0aGlzIHNjZW5hcmlvLiBQRyAxMyBoYXMgc3RhcnRlZCB0byBjaGFuZ2UgaXRzIGJlaGF2 aW9yLCB3aGljaCBtYWtlcyBvdXIgYXBwbGljYXRpb24gbmVlZCB0byBiZSBtb2RpZmllZC4gVGhp cyBpcyB0aGUgZmlyc3QgdGltZSBJIGhhdmUgZXZlciBzZWVuIGEgUEcgdXBncmFkZSBraWxsIGEg bmljZSBmZWF0dXJlLjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46MCI+PGJyPjwvcD48L2Rpdj48L2Js b2NrcXVvdGU+PGRpdj48YnI+PC9kaXY+PGRpdj5JdCB3YXMgbmV2ZXIgYSBmZWF0dXJlIGluIHRo ZSBmaXJzdCBwbGFjZSBzbyBub3RoaW5nIGhhcyBiZWVuIGtpbGxlZC4mbmJzcDsgVGhlIGRvY3Vt ZW50YXRpb24gc2F5cyB0aGUgZnVuY3Rpb24gbXVzdCBiZSBpbW11dGFibGUuJm5ic3A7IFlvdXIg ZnVuY3Rpb24gaXMgbm90LiZuYnNwOyBZb3Ugc2hvdWxkIGhhdmUgdXNlZCBhIHRyaWdnZXIsIGFu ZCB0aGUgZmFjdCB5b3UgaGFkIHRvIHdyaXRlIGEgd3JhcHBlciBmdW5jdGlvbiB0byBoYWNrIHRo ZSB2b2xhdGlsaXR5IG1lYW5zIHRoYXQsIGZyYW5rbHksIGl0cyB5b3VyIGRpc3JlZ2FyZCBmb3Ig YSBrbm93biBsaW1pdGF0aW9uIHRoYXQgaGFzIHByb2R1Y2VkIHRoaXMgbmVlZCB0byBjaGFuZ2Ug eW91ciBhcHBsaWNhdGlvbiB3aXRoIHRoZSByZWxlYXNlIG9mIGEgbmV3IG1ham9yIHZlcnNpb24g LSBub3QgYW55IGJ1ZyBvciBkZWNpc2lvbiBvbiB0aGUgcGFydCBvZiBQb3N0Z3JlU1FMLjwvZGl2 PjxkaXY+PGJyPjwvZGl2PjxkaXY+RGF2aWQgSi48L2Rpdj4KPC9ibG9ja3F1b3RlPjwvZGl2Pg== ------=_Part_71803_1940473784.1622107294458--