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 1lm647-0008D1-PM for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 02:48:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lm646-000488-Lf for pgsql-bugs@arkaria.postgresql.org; Thu, 27 May 2021 02:48:06 +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 1lm646-00047M-Ez for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 02:48:06 +0000 Received: from m1538.mail.126.com ([220.181.15.38]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lm643-0006u4-P4 for pgsql-bugs@lists.postgresql.org; Thu, 27 May 2021 02:48:06 +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=ML/tx t2m4AMMzt0vx5f1rCEyr0EYnUEU+BHUtszclf4=; b=c2Oou5fyZ5E4Ipxd4bovd m6adxxQZxLyLMVjI3+vTdMhyAww+HfFsaGURVvGQ3txNmtlvcSnE9/x0MGi9B6Su 4U0ksKfOOBMxCRBPkHNi38XB9GHdS+SM8v7EyWvfebjkApgMYvHdy9kfTxGl5kC3 ZbclSB3HJZAWOzIvwOi9VQ= Received: from digoal$126.com ( [42.120.75.254] ) by ajax-webmail-wmsvr38 (Coremail) ; Thu, 27 May 2021 10:47:59 +0800 (CST) X-Originating-IP: [42.120.75.254] Date: Thu, 27 May 2021 10:47:59 +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> Content-Type: multipart/alternative; boundary="----=_Part_23409_886350693.1622083679935" MIME-Version: 1.0 Message-ID: <2e46e6b5.1930.179abb8b6c0.Coremail.digoal@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: JsqowAAHD0NgCK9geyFXAQ--.54824W X-CM-SenderInfo: 5glj0tbo6rjloofrz/1tbiTwefl1pEEIbQGgADsB X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_23409_886350693.1622083679935 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 CgpUaGUgZ2VuZXJhdGVkIGNvbHVtbiBjYW4gYmUgdXNlZCB0byBhdXRvbWF0aWNhbGx5IGdlbmVy YXRlIHRoZSBtb2RpZmllZCB0aW1lc3RhbXAgb2YgYSB0dXBsZSwgYnV0IFBHIDEyIGN1cnJlbnRs eSBzdXBwb3J0cyB0aGlzIHNjZW5hcmlvLiBQRyAxMyBoYXMgc3RhcnRlZCB0byBjaGFuZ2UgaXRz IGJlaGF2aW9yLCB3aGljaCBtYWtlcyBvdXIgYXBwbGljYXRpb24gbmVlZCB0byBiZSBtb2RpZmll ZC4gVGhpcyBpcyB0aGUgZmlyc3QgdGltZSBJIGhhdmUgZXZlciBzZWVuIGEgUEcgdXBncmFkZSBr aWxsIGEgbmljZSBmZWF0dXJlLgoKCgoKCgoKCgoKCgoKLS0KCrmr0ubKx9K7sbLX07XEysIsSSdt IERpZ29hbCxKdXN0IERvIEl0LgoKCgoKCtTaIDIwMjEtMDUtMjcgMTA6MzM6NDCjrCJEYXZpZCBH LiBKb2huc3RvbiIgPGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tPiDQtLXAo7oKCk9uIFdlZG5l c2RheSwgTWF5IDI2LCAyMDIxLCC1wrjnIDxkaWdvYWxAMTI2LmNvbT4gd3JvdGU6CgoKCgoKQW5k IGltbXV0YWJsZSBmdW5jdGlvbiBpcyBzdGFibGUgd2hlbiBwYXJhbWV0ZXIgbm90IGNoYW5nZSwg d2hlbiBwYXJhbWV0ZXIgY2hhbmdlZCAsIHRoZSBpbW11dGFibGUgZnVuY3Rpb24gd2lsbCByZWNh bGwgYW5kIHJlY29tcHV0ZS4KYnV0IGluIFBHIDEzIGFuZCBQRyAxNCAsIGl0IGlzIGFsc28gd3Jv bmcuCgoKYGBgCmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIGltX25vdyAoYW55ZWxlbWVudCkg cmV0dXJucyB0aW1lc3RhbXB0eiBhcyAkJCAgCiAgc2VsZWN0IG5vdygpOyAgCiQkIGxhbmd1YWdl IHNxbCBzdHJpY3QgaW1tdXRhYmxlOyAKCgpjcmVhdGUgdGFibGUgdDEgKGlkIGludCBwcmltYXJ5 IGtleSwgYzEgaW50LCBpbmZvIHRleHQsIGNydF90aW1lIHRpbWVzdGFtcCwgCm1vZF90aW1lIHRp bWVzdGFtcCBHRU5FUkFURUQgQUxXQVlTIEFTIChpbV9ub3codDEpKSBzdG9yZWQpOyAKIApUaGlz IHNlZW1zIHRvIGJlIHJlbGF0ZWQgdG8gdGhpcyBhbHJlYWR5IHJlcG9ydGVkIGJ1ZyAodGhlIHNp bWlsYXIgb25lIEkgbm90ZWQgaW4gbXkgb3RoZXIgcmVwbHkpLgoKCmh0dHBzOi8vd3d3LnBvc3Rn cmVzcWwub3JnL21lc3NhZ2UtaWQvQ0FNX0RFaVdSMkRQVDZVNHhiLUVoaWdvenpkM24zRzM3WkIx JTJCODY3emJzRVZ0WW9Kd3clNDBtYWlsLmdtYWlsLmNvbQoKCgpEYXZpZCBKLg== ------=_Part_23409_886350693.1622083679935 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L2Rpdj48ZGl2 IHN0eWxlPSJtYXJnaW46IDA7Ij5UaGUgZ2VuZXJhdGVkIGNvbHVtbiBjYW4gYmUgdXNlZCB0byBh dXRvbWF0aWNhbGx5IGdlbmVyYXRlIHRoZSBtb2RpZmllZCB0aW1lc3RhbXAgb2YgYSB0dXBsZSwg YnV0IFBHIDEyIGN1cnJlbnRseSBzdXBwb3J0cyB0aGlzIHNjZW5hcmlvLiBQRyAxMyBoYXMgc3Rh cnRlZCB0byBjaGFuZ2UgaXRzIGJlaGF2aW9yLCB3aGljaCBtYWtlcyBvdXIgYXBwbGljYXRpb24g bmVlZCB0byBiZSBtb2RpZmllZC4gVGhpcyBpcyB0aGUgZmlyc3QgdGltZSBJIGhhdmUgZXZlciBz ZWVuIGEgUEcgdXBncmFkZSBraWxsIGEgbmljZSBmZWF0dXJlLjwvZGl2PjxwIHN0eWxlPSJtYXJn aW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJt YXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5 bGU9InBvc2l0aW9uOnJlbGF0aXZlO3pvb206MSI+PHAgc3R5bGU9Im1hcmdpbjogMCI+LS08L3A+ uavS5srH0ruxstfTtcTKwixJJ20gRGlnb2FsLEp1c3QgRG8gSXQuPGJyPjxkaXYgc3R5bGU9ImNs ZWFyOmJvdGgiPjwvZGl2PjwvZGl2PjxkaXYgaWQ9ImRpdk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+ PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHA+1NogMjAyMS0wNS0yNyAxMDozMzo0MKOs IkRhdmlkIEcuIEpvaG5zdG9uIiAmbHQ7ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20mZ3Q7INC0 tcCjujwvcD48YmxvY2txdW90ZSBpZD0iaXNSZXBseUNvbnRlbnQiIHN0eWxlPSJQQURESU5HLUxF RlQ6IDFleDsgTUFSR0lOOiAwcHggMHB4IDBweCAwLjhleDsgQk9SREVSLUxFRlQ6ICNjY2MgMXB4 IHNvbGlkIj5PbiBXZWRuZXNkYXksIE1heSAyNiwgMjAyMSwgtcK45yAmbHQ7PGEgaHJlZj0ibWFp bHRvOmRpZ29hbEAxMjYuY29tIj5kaWdvYWxAMTI2LmNvbTwvYT4mZ3Q7IHdyb3RlOjxicj48Ymxv Y2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDtib3Jk ZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2IHN0eWxlPSJsaW5l LWhlaWdodDoxLjc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlh bCI+PHAgc3R5bGU9Im1hcmdpbjowIj48YnI+PC9wPjxkaXYgc3R5bGU9Im1hcmdpbjowIj5BbmQg aW1tdXRhYmxlIGZ1bmN0aW9uIGlzIHN0YWJsZSB3aGVuIHBhcmFtZXRlciBub3QgY2hhbmdlLCB3 aGVuIHBhcmFtZXRlciBjaGFuZ2VkICwgdGhlIGltbXV0YWJsZSBmdW5jdGlvbiB3aWxsIHJlY2Fs bCBhbmQgcmVjb21wdXRlLjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowIj5idXQgaW4gUEcgMTMg YW5kIFBHIDE0ICwgaXQgaXMgYWxzbyB3cm9uZy48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MCI+ PGJyPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowIj5gYGA8L2Rpdj48ZGl2IHN0eWxlPSJtYXJn aW46MCI+PGRpdiBzdHlsZT0ibWFyZ2luOjAiPmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIGlt X25vdyAoYW55ZWxlbWVudCkgcmV0dXJucyB0aW1lc3RhbXB0eiBhcyAkJCZuYnNwOyZuYnNwOzwv ZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowIj4mbmJzcDsgc2VsZWN0IG5vdygpOyZuYnNwOyZuYnNw OzwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjowIj4kJCBsYW5ndWFnZSBzcWwgc3RyaWN0IGltbXV0 YWJsZTsmbmJzcDs8L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46MCI+PGJyPjwvZGl2PjxkaXYgc3R5 bGU9Im1hcmdpbjowIj5jcmVhdGUgdGFibGUgdDEgKGlkIGludCBwcmltYXJ5IGtleSwgYzEgaW50 LCBpbmZvIHRleHQsIGNydF90aW1lIHRpbWVzdGFtcCwmbmJzcDs8L2Rpdj48ZGl2IHN0eWxlPSJt YXJnaW46MCI+bW9kX3RpbWUgdGltZXN0YW1wIEdFTkVSQVRFRCBBTFdBWVMgQVMgKGltX25vdyh0 MSkpIHN0b3JlZCk7Jm5ic3A7PC9kaXY+PC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPjxkaXY+Jm5i c3A7PC9kaXY+PGRpdj5UaGlzIHNlZW1zIHRvIGJlIHJlbGF0ZWQgdG8gdGhpcyBhbHJlYWR5IHJl cG9ydGVkIGJ1ZyAodGhlIHNpbWlsYXIgb25lIEkgbm90ZWQgaW4gbXkgb3RoZXIgcmVwbHkpLjwv ZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvbWVzc2FnZS1pZC9DQU1fREVpV1IyRFBUNlU0eGItRWhpZ296emQzbjNHMzdaQjElMkI4Njd6 YnNFVnRZb0p3dyU0MG1haWwuZ21haWwuY29tIj5odHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t ZXNzYWdlLWlkL0NBTV9ERWlXUjJEUFQ2VTR4Yi1FaGlnb3p6ZDNuM0czN1pCMSUyQjg2N3pic0VW dFlvSnd3JTQwbWFpbC5nbWFpbC5jb208L2E+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+ RGF2aWQgSi48L2Rpdj4KPC9ibG9ja3F1b3RlPjwvZGl2Pg== ------=_Part_23409_886350693.1622083679935--