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 1kG3ig-0007w2-EY for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Sep 2020 17:17:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kG3if-0007Sm-Bb for pgsql-bugs@arkaria.postgresql.org; Wed, 09 Sep 2020 17:17:17 +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 1kG2u7-0002mw-T2 for pgsql-bugs@lists.postgresql.org; Wed, 09 Sep 2020 16:25:03 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kG2u6-0000Ts-0D for pgsql-bugs@lists.postgresql.org; Wed, 09 Sep 2020 16:25:03 +0000 Content-Type: multipart/mixed; boundary="===============7118503522752437078==" MIME-Version: 1.0 Subject: BUG #16613: Built in suppress_redundant_updates_trigger() trigger not supressing redundant updates To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: stephane.desnault@gmail.com Reply-To: stephane.desnault@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 09 Sep 2020 16:25:00 +0000 Message-ID: <16613-d5d1f061f4d595d3@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7118503522752437078== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYxMwpMb2dnZWQgYnk6ICAgICAgICAgIFN0ZXBoYW5lIERlc25hdWx0 CkVtYWlsIGFkZHJlc3M6ICAgICAgc3RlcGhhbmUuZGVzbmF1bHRAZ21haWwuY29tClBvc3RncmVT UUwgdmVyc2lvbjogMTIuNApPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3JpcHRp b246ICAgICAgICAKCkEgZnVsbCBkZXNjcmlwdGlvbiB3YXMgYSBiaXQgdG9vIGxvbmcgZm9yIHRo ZSB0aXRsZS4gQSBtb3JlIGV4YWN0IHN1bW1hcnkKaXM6DQpUaGUgYnVpbHQtaW4gc3VwcHJlc3Nf cmVkdW5kYW50X3VwZGF0ZXNfdHJpZ2dlcigpIHRyaWdnZXIgaXMgbm90IHN1cHJlc3NpbmcKcmVk dW5kYW50IHVwZGF0ZXMgYWZ0ZXIgYW4gQUxURVIgVEFCTEUgLi4uIEFERCBDT0xVTU4uLi4NCg0K SGVyZSBhcmUgdGhlIHN0ZXBzIHRvIHJlcHJvZHVjZSB3aGF0IEkgc2F3Og0KSSBydW4gdGhlIGZv bGxvd2luZyBzY3JpcHQgaW4gcGdBZG1pbiwgd2l0aCBhdXRvY29tbWl0IHNldCB0byB0cnVlLg0K DQotLS0tLS0tLS0tLS0tLQ0KQ1JFQVRFIFRBQkxFIHRlc3QgKGlkIGludCwgdmFsIHRleHQpOw0K SU5TRVJUIElOVE8gdGVzdCBWQUxVRVMgKDEsICdvbmUnKSwgKDIsICd0d28nKTsNCg0KQ1JFQVRF IE9SIFJFUExBQ0UgRlVOQ1RJT04gYW1faV90b3VjaGVkKCkgUkVUVVJOUyB0cmlnZ2VyIExBTkdV QUdFCidwbHBnc3FsJw0KQVMgJEJPRFkkDQpCRUdJTg0KCVJBSVNFIE5PVElDRSAnWWVzLCBJIGFt IHRvdWNoZWQhJzsNCglSRVRVUk4gTkVXOw0KRU5EOw0KJEJPRFkkOw0KDQpDUkVBVEUgVFJJR0dF UiBhel90ZXN0X3N1cHByZXNzX3JlZHVuZGFudF91cGRhdGUNCiAgICBCRUZPUkUgVVBEQVRFIE9O IHB1YmxpYy50ZXN0DQogICAgRk9SIEVBQ0ggUk9XIEVYRUNVVEUgUFJPQ0VEVVJFIHN1cHByZXNz X3JlZHVuZGFudF91cGRhdGVzX3RyaWdnZXIoKTsNCg0KQ1JFQVRFIFRSSUdHRVIgYnpfYW1fSV90 b3VjaGVkDQogICAgQkVGT1JFIFVQREFURSBPTiBwdWJsaWMudGVzdCANCglGT1IgRUFDSCBST1cg RVhFQ1VURSBQUk9DRURVUkUgYW1faV90b3VjaGVkKCk7DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQoNCk5vdywgaWYgSSBydW4gDQoNClVQREFURSB0ZXN0IFNFVCBpZCA9IDEgV0hFUkUg aWQgPSAxOw0KDQogdGhlIHVwZGF0ZSBpcyBzdXBwcmVzc2VkIGJ5IHRoZSBmaXJzdCB0cmlnZ2Vy IHNpbmNlIHRoZSByb3cgaXMgbGVmdAp1bmNoYW5nZWQsIGFuZCBiel9hbV9pX3RvdWNoZWQoKSBu ZXZlciBmaXJlcywgYXMgZXhwZWN0ZWQuIFNvIGZhciBzbyBnb29kLg0KDQpCdXQgdGhlbiBJIHJ1 bjoNCg0KQUxURVIgVEFCTEUgdGVzdCBBREQgQ09MVU1OIG5ld19jb2wgaW50Ow0KDQphbmQgSSB0 aGVuIHJ1biBVUERBVEUgdGVzdCBTRVQgaWQgPSAxIFdIRVJFIGlkID0gMTsgYWdhaW4uDQoNClRo aXMgdGltZSwgdGhlIHVwZGF0ZSBpcyBOT1Qgc3VwcHJlc3NlZCBhbmQgYnpfYW1faV90b3VjaGVk KCkgZmlyZXMhIFBHQWRtaW4KKHY0KSByZXBvcnRzIHRoYXQgb25lIHJlY29yZCB3YXMgdXBkYXRl ZCwgbm90IHplcm8gbGlrZSB0aGUgdGltZSBiZWZvcmUuIA0KDQpUaGlzIGlzIGEgb25lLW9mZiBv Y2N1cnJlbmNlLiBGdXJ0aGVyIFVQREFURSB0ZXN0IFNFVCBpZCA9IDEgV0hFUkUgaWQgPSAxCndv cmsgYXMgZXhwZWN0ZWQuLi4gQnV0IHRoZW4gSSB0cmllZCBVUERBVEUgdGVzdCBTRVQgaWQgPSAy IFdIRVJFIGlkID0gMi4uLgphbmQgYWdhaW4gSSBoYXZlIHRoaXMgc3RyYW5nZSBiZWhhdmlvciAt IHRoZSB1cGRhdGUgaXMgbm90IHN1cHByZXNzZWQuDQoNCkFsc28sIGlmIHRoZSBzZWNvbmQgdHJp Z2dlciBkb2Vzbid0IGxldCB0aGUgdXBkYXRlIGdvIHRocm91Z2gKKGFtX2lfdG91Y2hlZCgpIHJl dHVybnMgTlVMTCByYXRoZXIgdGhhbiBORVcpLCB0aGVuIHN1YnNlcXVlbnQgdXBkYXRlcyBhcmUK TkVWRVIgc3VwcHJlc3NlZCwgaXQncyBub3QgYSAib25lLW9mZiIgYmVoYXZpb3IgYW55bW9yZS4K Cg== --===============7118503522752437078==--