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 1pZ71U-0005SE-8G for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Mar 2023 09:20:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pZ71T-0006IR-6H for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Mar 2023 09:20: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 1pZ5FX-0005Kq-II for pgsql-bugs@lists.postgresql.org; Mon, 06 Mar 2023 07:27:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZ5FT-0005M0-Ii for pgsql-bugs@lists.postgresql.org; Mon, 06 Mar 2023 07:27:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=i1EKuAnPx/Z2CqJa9HEdML1pdMjJj4uvES61gGH+JPw=; b=X4rzK8Dw5s698wClj71nhx8Z36 i9V25e4e4ZG4NxGtGXcirIpwmaGa6SVkmATkf3Y1/oYLe6qTmXzqB60iqp7NI1MPJlWOL1bJe0LN/ sSRDWJt5ofC0y0E13LNBknGdPzaRnCP4PkU1sZA2OyJpyooOFFaeL1j1+Gdvrm3BO9wfci193/Ydy nSz7ILUDH3yfc4VbDWaqxe/b7FV3g4yH6sGojLRUxDRHqnRk84kMgcSU0LTBB/HV395ocyLwbzhOW 7zDRt4fudQx7eTdzPPjSYe03skO3RNLeviKzvjylhF+8kh7rsKENHfCdaD63wrQP7vv5vSdiC5Rbw wIl6pT1Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZ5FR-0005Lj-9B for pgsql-bugs@lists.postgresql.org; Mon, 06 Mar 2023 07:27:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pZ5FN-007J3m-Hy for pgsql-bugs@lists.postgresql.org; Mon, 06 Mar 2023 07:27:02 +0000 Content-Type: multipart/mixed; boundary="===============4176687633476825622==" MIME-Version: 1.0 Subject: BUG #17823: Generated columns not always updated correctly To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hisahiro@freemind.co.jp Reply-To: hisahiro@freemind.co.jp, pgsql-bugs@lists.postgresql.org Date: Mon, 06 Mar 2023 07:26:42 +0000 Message-ID: <17823-b64909cf7d63de84@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4176687633476825622== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgyMwpMb2dnZWQgYnk6ICAgICAgICAgIEhpc2FoaXJvIEthdWNoaQpF bWFpbCBhZGRyZXNzOiAgICAgIGhpc2FoaXJvQGZyZWVtaW5kLmNvLmpwClBvc3RncmVTUUwgdmVy c2lvbjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyA3CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpJIGZvdW5kIHRoYXQgdGhlIGdlbmVyYXRlZCBjb2x1bW5zIGFyZSBzb21ldGltZXMgbm90 IHVwZGF0ZWQuDQoNCjEuIENyZWF0ZSBhIHRhYmxlIHdpdGggYSBnZW5lcmF0ZWQgY29sdW1uLCBh bmQgaW5zZXJ0IGEgcm93Og0KDQogICAgdGVzdD0jIGNyZWF0ZSB0YWJsZSB0ZXN0KGlkIHNlcmlh bCBwcmltYXJ5IGtleSwgYSBpbnQsIGIgaW50IGdlbmVyYXRlZAphbHdheXMgYXMgKGEgKyAxKSBz dG9yZWQpOw0KICAgIENSRUFURSBUQUJMRQ0KICAgIHRlc3Q9IyBpbnNlcnQgaW50byB0ZXN0KGEp IHZhbHVlcyAoMSk7DQogICAgSU5TRVJUIDAgMQ0KICAgIHRlc3Q9IyBzZWxlY3QgKiBmcm9tIHRl c3Q7DQogICAgIGlkIHwgYSB8IGINCiAgICAtLS0tKy0tLSstLS0NCiAgICAgIDEgfCAxIHwgMg0K ICAgICgxIHJvdykNCg0KMi4gU3RhcnQgVHJhbnNhY3Rpb24gQSBhbmQgdXBkYXRlIHRoZSByb3c6 DQoNCiAgICA9PT09IFRyYW5zYWN0aW9uIEEgPT09PQ0KDQogICAgdGVzdD0jIGJlZ2luOw0KICAg IEJFR0lODQogICAgdGVzdD0qIyB1cGRhdGUgdGVzdCBzZXQgYT0yIHdoZXJlIGlkPTE7DQogICAg VVBEQVRFIDENCiAgICB0ZXN0PSojIHNlbGVjdCAqIGZyb20gdGVzdDsNCiAgICAgaWQgfCBhIHwg Yg0KICAgIC0tLS0rLS0tKy0tLQ0KICAgICAgMSB8IDIgfCAzDQogICAgKDEgcm93KQ0KDQozLiBC ZWZvcmUgY29tbWl0dGluZyB0cmFuc2FjdGlvbiBBLCBzdGFydCBUcmFuc2FjdGlvbiBCIHRvIHVw ZGF0ZSB0aGUgc2FtZQpyb3c6DQoNCiAgICA9PT09IFRyYW5zYWN0aW9uIEIgPT09PQ0KDQogICAg dGVzdD0jIGJlZ2luOw0KICAgIEJFR0lODQogICAgdGVzdD0qIyB1cGRhdGUgdGVzdCBzZXQgYT0z IHdoZXJlIGlkPTE7DQoNCiAgICAoV2FpdGluZyBmb3IgVHJhbnNhY3Rpb24gQSB0byBjb21taXQp DQoNCjQuIENvbW1pdCBUcmFuc2FjdGlvbiBBOg0KDQogICAgPT09PSBUcmFuc2FjdGlvbiBBID09 PT0NCg0KICAgIHRlc3Q9KiMgZW5kOw0KICAgIENPTU1JVA0KDQo1LiBUaGUgVVBEQVRFIG9mIFRy YW5zYWN0aW9uIEIgaXMgZXhlY3V0ZWQ6DQoNCiAgICA9PT09IFRyYW5zYWN0aW9uIEIgPT09PQ0K DQogICAgVVBEQVRFIDENCiAgICB0ZXN0PSojIGVuZDsNCiAgICBDT01NSVQNCg0KNi4gQ2hlY2sg dGhlIHJlc3VsdDoNCg0KICAgIHRlc3Q9KiMgc2VsZWN0ICogZnJvbSB0ZXN0Ow0KICAgICBpZCB8 IGEgfCBiDQogICAgLS0tLSstLS0rLS0tDQogICAgICAxIHwgMyB8IDMNCiAgICAoMSByb3cpDQoN ClRoZSBnZW5lcmF0ZWQgY29sdW1uICJiIiBzaG91bGQgYmUgdXBkYXRlZCBjb3JyZWN0bHkgdG8g cmVmbGVjdCB0aGUgbmV3CnZhbHVlIG9mICJhIiAoaS5lLiwgYj00KS4KCg== --===============4176687633476825622==--