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 1pKgGn-0001KX-89 for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jan 2023 13:56:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pKgGm-0001AQ-2j for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Jan 2023 13:56:56 +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 1pKYU3-0005ZR-Bk for pgsql-bugs@lists.postgresql.org; Wed, 25 Jan 2023 05:38:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKYU1-0006Hk-4D for pgsql-bugs@lists.postgresql.org; Wed, 25 Jan 2023 05:38:06 +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=pM/2oD/Eyc/1ydzp7LpaxokRnmoX+RtVBUitFp+UG+Y=; b=iKtPYhgKoneDizmjFUmKcAlG+Z CxlK+tcnnYHrep5fSDK1EA2Y1vcGW9ZMDjIghJve6pDIIlrzVX8kWoLC04SbFRuNIcTs3hP4GGvjl bemrPDezza+nsCX8lSz8kcNRu81Pp+H2YYG4kySdLxAaVxkdtSGKLeNmSU94cHhyLEWXjlLmul4zG Jfc+Gm3dxxaYyXe1qmqwCfNv+URqJ+2gWNKHPHqyM51Yf1qZEQDZPH/kbNhoS3oXTnWhPDhlRKlSl cW2gCEOlZ5DkFWk+5OSiVOA3fg+EqvoEUi5oGlYntrxW3VBX27qYDHEV8BA6Pp3s0vdBuBQDT2LhG gGGMXrhg==; 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 1pKYU0-00060E-OP for pgsql-bugs@lists.postgresql.org; Wed, 25 Jan 2023 05:38:04 +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 1pKYTx-002zEd-CU for pgsql-bugs@lists.postgresql.org; Wed, 25 Jan 2023 05:38:02 +0000 Content-Type: multipart/mixed; boundary="===============1562864137136095209==" MIME-Version: 1.0 Subject: BUG #17759: MERGE UPDATE statements do not cause generated columns to update To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: adminnz@gmail.com Reply-To: adminnz@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 25 Jan 2023 05:37:57 +0000 Message-ID: <17759-e76d9bece1b5421c@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 --===============1562864137136095209== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc1OQpMb2dnZWQgYnk6ICAgICAgICAgIEt5cm8KRW1haWwgYWRkcmVz czogICAgICBhZG1pbm56QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE1LjEKT3BlcmF0 aW5nIHN5c3RlbTogICBEZWJpYW4gKERvY2tlcikKRGVzY3JpcHRpb246ICAgICAgICAKCkknbSBy dW5uaW5nIHRoZSBkb2NrZXIgaW1hZ2UgcG9zdGdpcy9wb3N0Z2lzOjE1LW1hc3RlciB3aGljaCBp cyByZXBvcnRpbmcgYXMKdmVyc2lvbiAiUG9zdGdyZVNRTCAxNS4xIChEZWJpYW4gMTUuMS0xLnBn ZGcxMTArMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwKY29tcGlsZWQgYnkgZ2NjIChEZWJpYW4g MTAuMi4xLTYpIDEwLjIuMSAyMDIxMDExMCwgNjQtYml0Ii4NCg0KQSB0YWJsZSB3aXRoICJHRU5F UkFURUQgQUxXQVlTIiBjb2x1bW5zIGRvIG5vdCBhcHBlYXIgdG8gZ2V0IHVwZGF0ZWQgd2hlbgp0 aGUgdXBkYXRlIGlzIGRvbmUgdmlhIGEgTUVSR0Ugc3RhdGVtZW50Lg0KQmVsb3cgaXMgc29tZSBT UUwgdGhhdCBjYW4gcmVwcm9kdWNlIHRoaXMgaXNzdWUuDQoNCi0tIGNyZWF0ZSB0YWJsZSB3aXRo IGdlbmVyYXRlZCBjb2x1bW4gdXNpbmcgZGF0YS10eXBlIHBvc3RnaXMsIGFuZCBhbHNvCmFub3Ro ZXIgd2l0aG91dCBwb3N0Z2lzIHRvIHNob3cgaXRzIG5vdCBsaW1pdGVkIHRvIHBvc3RnaXMgZGF0 YXR5cGUKY29sdW1ucw0KY3JlYXRlIHRhYmxlIGxhdGVzdF9wb3NpdGlvbg0KKA0KCWlkIHZhcmNo YXIoMTIpIG5vdCBudWxsDQoJLGxhdGl0dWRlIG51bWVyaWMoMTEsOCkgbm90IG51bGwNCgksbG9u Z2l0dWRlIG51bWVyaWMoMTEsOCkgbm90IG51bGwNCgkscG9pbnQgZ2VvZ3JhcGh5KFBPSU5UKSBH RU5FUkFURUQgQUxXQVlTIEFTIChTVF9QT0lOVChsb25naXR1ZGUsIGxhdGl0dWRlLAo0MzI2KTo6 Z2VvZ3JhcGh5KSBTVE9SRUQNCgkscG9pbnRfdGV4dCB0ZXh0IEdFTkVSQVRFRCBBTFdBWVMgQVMg KGxhdGl0dWRlOjp0ZXh0IHx8ICcgKyAnIHx8CmxvbmdpdHVkZTo6dGV4dCkgU1RPUkVEDQopOw0K DQotLWluc2VydCBzb21lIGRhdGEgdG8gdGVzdCBpZiBnZW5lcmF0ZWQgY29sdW1ucyB1cGRhdGUN Cmluc2VydCBpbnRvIGxhdGVzdF9wb3NpdGlvbiBWQUxVRVMgKCcxJywgLTMxLjM4NDgsIDE3My44 NDg0OCk7DQpzZWxlY3QgKiwgU1RfWShwb2ludDo6Z2VvbWV0cnkpLCBTVF9YKHBvaW50OjpnZW9t ZXRyeSkgZnJvbQpsYXRlc3RfcG9zaXRpb247DQotLSBTVF9ZICYgU1RfWCByZXN1bHQgaW4gLTMx LjM4NDgsIDE3My44NDg0OCByZXNwZWN0aXZlbHkgd2hpY2ggaXMgY29ycmVjdC4KDQotLSBhbmQg cG9pbnRfdGV4dCBjb2x1bW4gc2hvdWxkIGJlICItMzEuMzg0OCAmIDE3My44NDg0OCIgd2hpY2gg aXQgaXMuDQoNCi0tIHVwZGF0ZSBzb21lIGRhdGEgdG8gdGVzdCBpZiBnZW5lcmF0ZWQgY29sdW1u cyB1cGRhdGUNCnVwZGF0ZSBsYXRlc3RfcG9zaXRpb24gc2V0IGxhdGl0dWRlID0gLTQxLjM4NDgs IGxvbmdpdHVkZSA9IDE0My4zMzIyMTEgd2hlcmUKaWQgPSAnMSc7DQpzZWxlY3QgKiwgU1RfWShw b2ludDo6Z2VvbWV0cnkpLCBTVF9YKHBvaW50OjpnZW9tZXRyeSkgZnJvbQpsYXRlc3RfcG9zaXRp b247DQotLSBTVF9ZICYgU1RfWCByZXN1bHQgaW4gLTQxLjM4NDgsIDE0My4zMzIyMTEgcmVzcGVj dGl2ZWx5IHdoaWNoIGlzIGNvcnJlY3QuCg0KLS0gYW5kIHBvaW50X3RleHQgY29sdW1uIHNob3Vs ZCBiZSAiLTQxLjM4NDggJiAxNDMuMzMyMjExIiB3aGljaCBpdCBpcy4NCg0KDQotLSB1cGRhdGUg c29tZSBkYXRhIHZpYSBtZXJnZSB0byB0ZXN0IGlmIGdlbmVyYXRlZCBjb2x1bW5zIHVwZGF0ZQ0K TUVSR0UgSU5UTyBsYXRlc3RfcG9zaXRpb24gYXMgdHJnDQpVU0lORwooVkFMVUVTKCcxJzo6dmFy Y2hhcigxMiksLTUxLjMzMTI2ODQ6Om51bWVyaWMoMTEsOCksMTczLjIwNDE0ODI6Om51bWVyaWMo MTEsOCkpKQphcyBzcmMoaWQsbGF0aXR1ZGUsbG9uZ2l0dWRlKQ0KT04gdHJnLmlkID0gc3JjLmlk DQpXSEVOIE1BVENIRUQgVEhFTg0KVVBEQVRFIFNFVCBsYXRpdHVkZSA9IHNyYy5sYXRpdHVkZSwg bG9uZ2l0dWRlID0gc3JjLmxvbmdpdHVkZTsNCg0Kc2VsZWN0ICosIFNUX1kocG9pbnQ6Omdlb21l dHJ5KSwgU1RfWChwb2ludDo6Z2VvbWV0cnkpIGZyb20KbGF0ZXN0X3Bvc2l0aW9uOw0KLS0gU1Rf WSAmIFNUX1ggZG8gbm90IHJlc3VsdCBpbiA1MS4zMzEyNjg0LCAxNzMuMjA0MTQ4MiByZXNwZWN0 aXZlbHkgd2hpY2gKaXMgaW5jb3JyZWN0LiANCi0tIGFuZCBwb2ludF90ZXh0IGNvbHVtbiBzaG91 bGQgYmUgIi00MS4zODQ4ICYgMTQzLjMzMjIxMSIgYnV0IGl0IGlzbnQuCgo= --===============1562864137136095209==--