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 1lmCG4-0005gl-Ix for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 09:24:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmCG3-0007Yp-Im for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 09:24:51 +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 1lmCG3-0007Yg-CN for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 09:24:51 +0000 Received: from m1546.mail.126.com ([220.181.15.46]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmCG0-0000RH-57 for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 09:24:50 +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=q6Lk5 dp+RwQNgmLJj2EN1Cl0ZogNuEs14Sq01RJLXoU=; b=G6dWe8Edku8r4pmJ++fK/ 2MmNusGIvJGrpbIZLZ/CRF4b0NzBqtoVhnlQ5gqV/2dNFxN5cfQ2WMLMwtPXPn2Y PeWI9NG3MRDFkkmfMytOJWBrrG4e5Sqt8LjA4k7sVq2TRzol0ZS962rPX14t2oj6 MqIRCOSTw6Y9ZoHkOUFN/I= Received: from digoal$126.com ( [42.120.75.254] ) by ajax-webmail-wmsvr46 (Coremail) ; Thu, 27 May 2021 17:24:44 +0800 (CST) X-Originating-IP: [42.120.75.254] Date: Thu, 27 May 2021 17:24:44 +0800 (CST) From: =?GBK?B?tcK45w==?= To: "Tom Lane" Cc: "David G. Johnston" , "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: <1684301.1622084940@sss.pgh.pa.us> References: <17036-e4d41f4221873a17@postgresql.org> <23824c32.12e8.179ab97fa8a.Coremail.digoal@126.com> <2e46e6b5.1930.179abb8b6c0.Coremail.digoal@126.com> <1684301.1622084940@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="----=_Part_72207_1156463403.1622107484937" MIME-Version: 1.0 Message-ID: <574cb2f7.4da8.179ad23f309.Coremail.digoal@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: LsqowADXLQVcZa9g6R1XAQ--.9545W X-CM-SenderInfo: 5glj0tbo6rjloofrz/1tbiuwWfl1pEEI--ogACso X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_72207_1156463403.1622107484937 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 CgoKVGhhbmsgeW91IFRvbSBMYW5lIGZvciB5b3VyIHJlcGx5LiBJIHRoaW5rIHlvdXIgZXhwbGFu YXRpb24gaXMgdmVyeSBjbGVhci4KClNvIGNhbiB3ZSB0YWxrIGFib3V0IHRoZSB1c2Ugb2Ygdm9s YXRpbGUgb3Igc3RhYmxlIGZ1bmN0aW9ucyBpbiBnZW5lcmF0ZWQgY29sdW1ucyBhbmQgaWYgdGhl cmUgYXJlIGFjdHVhbCBidXNpbmVzcyBzY2VuYXJpb3MsIHdoeSBub3QgZGVzaWduIHRoZSBmdW5j dGlvbmFsaXR5IGZyb20gdGhlIHBlcnNwZWN0aXZlIG9mIHRoZSBzY2VuYXJpb3MgaW5zdGVhZCBv ZiB0aGUgc2NlbmFyaW9zPwoKCgoKCgoKCgoKLS0KCrmr0ubKx9K7sbLX07XEysIsSSdtIERpZ29h bCxKdXN0IERvIEl0LgoKCgoKCgpBdCAyMDIxLTA1LTI3IDExOjA5OjAwLCAiVG9tIExhbmUiIDx0 Z2xAc3NzLnBnaC5wYS51cz4gd3JvdGU6Cj49P0dCSz9CP3RjSzQ1dz09Pz0gPGRpZ29hbEAxMjYu Y29tPiB3cml0ZXM6Cj4+IFRoZSBnZW5lcmF0ZWQgY29sdW1uIGNhbiBiZSB1c2VkIHRvIGF1dG9t YXRpY2FsbHkgZ2VuZXJhdGUgdGhlIG1vZGlmaWVkIHRpbWVzdGFtcCBvZiBhIHR1cGxlLCBidXQg UEcgMTIgY3VycmVudGx5IHN1cHBvcnRzIHRoaXMgc2NlbmFyaW8uIFBHIDEzIGhhcyBzdGFydGVk IHRvIGNoYW5nZSBpdHMgYmVoYXZpb3IsIHdoaWNoIG1ha2VzIG91ciBhcHBsaWNhdGlvbiBuZWVk IHRvIGJlIG1vZGlmaWVkLiBUaGlzIGlzIHRoZSBmaXJzdCB0aW1lIEkgaGF2ZSBldmVyIHNlZW4g YSBQRyB1cGdyYWRlIGtpbGwgYSBuaWNlIGZlYXR1cmUuCj4KPllvdSBoYXZlIGJlZW4gdG9sZCBz ZXZlcmFsIHRpbWVzIGFscmVhZHkgdGhhdCB0aGlzIGlzIG5vdCBhICJmZWF0dXJlIi4KPlRoZSBw b2ludCBvZiB0aGUgcmVzdHJpY3Rpb24gdGhhdCBHRU5FUkFURUQgZXhwcmVzc2lvbnMgYmUgaW1t dXRhYmxlCj5pcyB0aGF0IHRoZSBpbXBsZW1lbnRhdGlvbiBuZWVkIG5vdCByZWNvbXB1dGUgdGhl bSBkdXJpbmcgVVBEQVRFCj4oaWYgbm9uZSBvZiB0aGVpciBpbnB1dCBjb2x1bW5zIGNoYW5nZWQp Lgo+Cj5JZiB2MTIgZmFpbGVkIHRvIGV4cGxvaXQgdGhhdCBmdWxseSwgdGhhdCdzIG1vcmUgYSBi dWcgaW4gdjEyIHRoYW4KPml0IGlzIGluIHZlcnNpb25zIHRoYXQgZG8gZXhwbG9pdCBpdC4KPgo+ SWYgeW91IG5lZWQgdG8gdXBkYXRlIGEgY29sdW1uIGR1cmluZyBldmVyeSB1cGRhdGUsIHRoZSBi ZXN0IHdheQo+dG8gZG8gdGhhdCBpcyB3aXRoIGEgQkVGT1JFIElOU0VSVCBPUiBVUERBVEUgdHJp Z2dlci4KPgo+SSB3aWxsIGFsc28gc3RhdGUgY2F0ZWdvcmljYWxseSB0aGF0IGx5aW5nIGFib3V0 IHRoZSBtdXRhYmlsaXR5Cj5vZiBhIGZ1bmN0aW9uIGlzIGEgdGVjaG5pcXVlIHRoYXQgd2lsbCBi aXRlIHlvdSBvbiB0aGUgcmVhciwgYW5kCj55b3Ugd2lsbCBnZXQgbm8gc3ltcGF0aHkgd2hlbiBp dCBkb2VzLiAgSWYgaXQgZG9lcyB3aGF0IHlvdSB3YW50Cj5pbiB2ZXJzaW9uIE4sIGZpbmUsIGJ1 dCBkb24ndCB3aGluZSB3aGVuIGl0IGJyZWFrcyBpbiBOKzEuCj4KPgkJCXJlZ2FyZHMsIHRvbSBs YW5lCg== ------=_Part_72207_1156463403.1622107484937 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxl PSJtYXJnaW46IDA7Ij5UaGFuayB5b3UgVG9tIExhbmUgZm9yIHlvdXIgcmVwbHkuIEkgdGhpbmsg eW91ciBleHBsYW5hdGlvbiBpcyB2ZXJ5IGNsZWFyLjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+ U28gY2FuIHdlIHRhbGsgYWJvdXQgdGhlIHVzZSBvZiB2b2xhdGlsZSBvciBzdGFibGUgZnVuY3Rp b25zIGluIGdlbmVyYXRlZCBjb2x1bW5zIGFuZCBpZiB0aGVyZSBhcmUgYWN0dWFsIGJ1c2luZXNz IHNjZW5hcmlvcywgd2h5IG5vdCBkZXNpZ24gdGhlIGZ1bmN0aW9uYWxpdHkgZnJvbSB0aGUgcGVy c3BlY3RpdmUgb2YgdGhlIHNjZW5hcmlvcyBpbnN0ZWFkIG9mIHRoZSBzY2VuYXJpb3M/PC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9w PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0aW9uOnJlbGF0 aXZlO3pvb206MSI+PHAgc3R5bGU9Im1hcmdpbjogMCI+LS08L3A+uavS5srH0ruxstfTtcTKwixJ J20gRGlnb2FsLEp1c3QgRG8gSXQuPGJyPjxkaXYgc3R5bGU9ImNsZWFyOmJvdGgiPjwvZGl2Pjwv ZGl2PjxkaXYgaWQ9ImRpdk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjog MDsiPjxicj48L3A+PHByZT48YnI+QXQgMjAyMS0wNS0yNyAxMTowOTowMCwgIlRvbSBMYW5lIiAm bHQ7dGdsQHNzcy5wZ2gucGEudXMmZ3Q7IHdyb3RlOgomZ3Q7PT9HQks/Qj90Y0s0NXc9PT89ICZs dDtkaWdvYWxAMTI2LmNvbSZndDsgd3JpdGVzOgomZ3Q7Jmd0OyBUaGUgZ2VuZXJhdGVkIGNvbHVt biBjYW4gYmUgdXNlZCB0byBhdXRvbWF0aWNhbGx5IGdlbmVyYXRlIHRoZSBtb2RpZmllZCB0aW1l c3RhbXAgb2YgYSB0dXBsZSwgYnV0IFBHIDEyIGN1cnJlbnRseSBzdXBwb3J0cyB0aGlzIHNjZW5h cmlvLiBQRyAxMyBoYXMgc3RhcnRlZCB0byBjaGFuZ2UgaXRzIGJlaGF2aW9yLCB3aGljaCBtYWtl cyBvdXIgYXBwbGljYXRpb24gbmVlZCB0byBiZSBtb2RpZmllZC4gVGhpcyBpcyB0aGUgZmlyc3Qg dGltZSBJIGhhdmUgZXZlciBzZWVuIGEgUEcgdXBncmFkZSBraWxsIGEgbmljZSBmZWF0dXJlLgom Z3Q7CiZndDtZb3UgaGF2ZSBiZWVuIHRvbGQgc2V2ZXJhbCB0aW1lcyBhbHJlYWR5IHRoYXQgdGhp cyBpcyBub3QgYSAiZmVhdHVyZSIuCiZndDtUaGUgcG9pbnQgb2YgdGhlIHJlc3RyaWN0aW9uIHRo YXQgR0VORVJBVEVEIGV4cHJlc3Npb25zIGJlIGltbXV0YWJsZQomZ3Q7aXMgdGhhdCB0aGUgaW1w bGVtZW50YXRpb24gbmVlZCBub3QgcmVjb21wdXRlIHRoZW0gZHVyaW5nIFVQREFURQomZ3Q7KGlm IG5vbmUgb2YgdGhlaXIgaW5wdXQgY29sdW1ucyBjaGFuZ2VkKS4KJmd0OwomZ3Q7SWYgdjEyIGZh aWxlZCB0byBleHBsb2l0IHRoYXQgZnVsbHksIHRoYXQncyBtb3JlIGEgYnVnIGluIHYxMiB0aGFu CiZndDtpdCBpcyBpbiB2ZXJzaW9ucyB0aGF0IGRvIGV4cGxvaXQgaXQuCiZndDsKJmd0O0lmIHlv dSBuZWVkIHRvIHVwZGF0ZSBhIGNvbHVtbiBkdXJpbmcgZXZlcnkgdXBkYXRlLCB0aGUgYmVzdCB3 YXkKJmd0O3RvIGRvIHRoYXQgaXMgd2l0aCBhIEJFRk9SRSBJTlNFUlQgT1IgVVBEQVRFIHRyaWdn ZXIuCiZndDsKJmd0O0kgd2lsbCBhbHNvIHN0YXRlIGNhdGVnb3JpY2FsbHkgdGhhdCBseWluZyBh Ym91dCB0aGUgbXV0YWJpbGl0eQomZ3Q7b2YgYSBmdW5jdGlvbiBpcyBhIHRlY2huaXF1ZSB0aGF0 IHdpbGwgYml0ZSB5b3Ugb24gdGhlIHJlYXIsIGFuZAomZ3Q7eW91IHdpbGwgZ2V0IG5vIHN5bXBh dGh5IHdoZW4gaXQgZG9lcy4gIElmIGl0IGRvZXMgd2hhdCB5b3Ugd2FudAomZ3Q7aW4gdmVyc2lv biBOLCBmaW5lLCBidXQgZG9uJ3Qgd2hpbmUgd2hlbiBpdCBicmVha3MgaW4gTisxLgomZ3Q7CiZn dDsJCQlyZWdhcmRzLCB0b20gbGFuZQo8L3ByZT48L2Rpdj4= ------=_Part_72207_1156463403.1622107484937--