Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inP5b-0006EG-Du for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Jan 2020 15:42:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1inP5Z-00069P-CR for pgsql-bugs@arkaria.postgresql.org; Fri, 03 Jan 2020 15:42:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1inP5Z-00069I-41 for pgsql-bugs@lists.postgresql.org; Fri, 03 Jan 2020 15:42:13 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1inP5R-00034v-P6 for pgsql-bugs@lists.postgresql.org; Fri, 03 Jan 2020 15:42:12 +0000 Content-Type: multipart/mixed; boundary="===============0675411104841942548==" MIME-Version: 1.0 Subject: BUG #16185: Trigger fires twice and with wrong TG_OP when updating partion key on partitioned table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: henry.hinze@gmail.com Reply-To: henry.hinze@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 03 Jan 2020 15:41:21 +0000 Message-ID: <16185-ad3eced5747aa2b8@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============0675411104841942548== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE4NQpMb2dnZWQgYnk6ICAgICAgICAgIEhlbnJ5IEhpbnplCkVtYWls IGFkZHJlc3M6ICAgICAgaGVucnkuaGluemVAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTIuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxNi4wNC42IExUUwpEZXNjcmlwdGlvbjog ICAgICAgIAoKSWYgYSB0cmlnZ2VyIGlzIGRlZmluZWQgb24gYSBwYXJ0aXRpb25lZCB0YWJsZSBh bmQgdGhlIHBhcnRpdGlvbiBrZXkgaXMKdXBkYXRlZCB0aGF0IHRoZSByb3cgaXMgbW92ZWQgdG8g YW5vdGhlciBwYXJ0aXRpb24sIHRoZW4gdGhlIHRyaWdnZXIgaXMKZmlyZWQgdHdpY2UgZmlyc3Qg d2l0aCBUR19PUCA9ICdERUxFVEUnIGZvbGxvd2VkIGJ5IFRHX09QID0gJ0lOU0VSVCcuICBBcyBh CnVzZXIgSSB3b3VsZCBleHBlY3QgdGhhdCB0aGUgdHJpZ2dlciBmaXJlcyBvbmx5IG9uY2Ugd2l0 aCBUR19PUCA9CidVUERBVEUnLg0KDQpUbyByZXByb2R1Y2U6DQoqKioqKioqKioqKioqKioqDQpj cmVhdGUgdGFibGUgdCAoaWQgaW50LCBwX2tleSBpbnQpIHBhcnRpdGlvbiBieSBsaXN0IChwX2tl eSk7DQoNCmNyZWF0ZSB0YWJsZSB0MSBwYXJ0aXRpb24gb2YgdCBmb3IgdmFsdWVzIGluICgxKTsN CmNyZWF0ZSB0YWJsZSB0MiBwYXJ0aXRpb24gb2YgdCBmb3IgdmFsdWVzIGluICgyKTsNCg0KaW5z ZXJ0IGludG8gdCAoaWQscF9rZXkpIHZhbHVlcyAoMSwxKTsNCg0KY3JlYXRlIG9yIHJlcGxhY2Ug ZnVuY3Rpb24gZigpDQogICAgUkVUVVJOUyBUUklHR0VSDQogICAgTEFOR1VBR0UgcGxwZ3NxbA0K QVMNCiRmdW5jdGlvbiQNCkJFR0lODQogICAgUkFJU0UgTk9USUNFICdUR19PUDogJScsIFRHX09Q Ow0KICAgIFJFVFVSTiBOVUxMOw0KRU5EOw0KJGZ1bmN0aW9uJDsNCg0KQ1JFQVRFIFRSSUdHRVIg Zl90cmlnDQogICAgQUZURVIgSU5TRVJUIG9yIFVQREFURSBvciBERUxFVEUNCiAgICBPTiB0DQog ICAgRk9SIEVBQ0ggUk9XDQpFWEVDVVRFIFBST0NFRFVSRSBmKCk7DQoNCnBvc3RncmVzPSMgdXBk YXRlIHQgc2V0IHBfa2V5ID0gMiB3aGVyZSBpZCA9IDE7DQpOT1RJQ0U6ICBUR19PUDogREVMRVRF DQpOT1RJQ0U6ICBUR19PUDogSU5TRVJUDQpVUERBVEUgMQoK --===============0675411104841942548==--