Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3IyN-00BeGz-QS for pgsql-bugs@arkaria.postgresql.org; Sat, 04 May 2024 17:14:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s3IyL-0014iU-9b for pgsql-bugs@arkaria.postgresql.org; Sat, 04 May 2024 17:14:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2u34-00A3BA-Qr for pgsql-bugs@lists.postgresql.org; Fri, 03 May 2024 14:38:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2u33-001FyO-Aq for pgsql-bugs@lists.postgresql.org; Fri, 03 May 2024 14: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=LbaUI/z15fit2UQ0UQFgVFThac3DNiwywvV0EXvlR/o=; b=TsQ5GhiLRFnWt5O9FpIStS80vL wCrjiu+Q/wMlfHcoRDMLoTJnmiR3eCOL6+iVny+DzNnJk70LmPMNfu1aILRXaRhx/4B5z4MFETU+W j2iSUmP9n9uig3Ze/WkccCJuM4QNyEPc+2acjhPpE5ZCXRcZz9DqEjX2NKFd4D22jZgu7Qrj+JfCR 972lkNGfTTqoISpqHc7GDFxXzvarjKtuujIx0u5h5qg5Jbx5SkMNhBv3dvfE6+4IDjga2m3qB1P1H gFijfmG7Jq1zTKshh5sr1+bt8oMQz85YZ3DnAzbZvzeFnIZQorySQOYIh9Prr4kjbgxhb30cfURYy kZK8MaBw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2u31-0042w5-SW for pgsql-bugs@lists.postgresql.org; Fri, 03 May 2024 14: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 1s2u2z-009gRZ-TY for pgsql-bugs@lists.postgresql.org; Fri, 03 May 2024 14:38:02 +0000 Content-Type: multipart/mixed; boundary="===============5638809168788147464==" MIME-Version: 1.0 Subject: BUG #18456: Trigger data in plpython3u trigger-function changes in AFTER UPDATE OR INSERT trigger To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jacques@quantsolutions.co.za Reply-To: jacques@quantsolutions.co.za, pgsql-bugs@lists.postgresql.org Date: Fri, 03 May 2024 14:37:12 +0000 Message-ID: <18456-82d3d70134aefd28@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 --===============5638809168788147464== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ1NgpMb2dnZWQgYnk6ICAgICAgICAgIEphY3F1ZXMgQ29tYnJpbmsK RW1haWwgYWRkcmVzczogICAgICBqYWNxdWVzQHF1YW50c29sdXRpb25zLmNvLnphClBvc3RncmVT UUwgdmVyc2lvbjogMTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNC40IExUUwpE ZXNjcmlwdGlvbjogICAgICAgIAoKUG9zdGdyZXMgdmVyc2lvbjogUG9zdGdyZVNRTCAxNi4yIChV YnVudHUgMTYuMi0xLnBnZGcyMC4wNCsxKSBvbgp4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxl ZCBieSBnY2MgKFVidW50dSA5LjQuMC0xdWJ1bnR1MX4yMC4wNC4yKSA5LjQuMCwKNjQtYml0DQoN CkNyZWF0ZSB0aGUgdGFibGUsIGluc2VydCBvbmUgcmVjb3JkLCBjcmVhdGUgZnVuY3Rpb24gYW5k IHRyaWdnZXIuDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQ0KQ1JFQVRFIFRBQkxFIHRlc3QgKA0KICAgIGlkIFNFUklBTCwNCiAgICBudW1iZXIgaW50DQop Ow0KSU5TRVJUIElOVE8gdGVzdChudW1iZXIpIFZBTFVFUyAoMCk7DQoNCkNSRUFURSBPUiBSRVBM QUNFIEZVTkNUSU9OIHRyZWVnZXIoKQ0KUkVUVVJOUyB0cmlnZ2VyDQpBUyAkQk9EWSQNCiAgICBp ZiBub3QgVERbIm5ldyJdWyJudW1iZXIiXSA+IDUwOg0KICAgICAgICByZXR1cm4gTm9uZQ0KICAg IHBscHkud2FybmluZyhURCkgIyBMT0cgMQ0KICAgIHBscHkuZXhlY3V0ZSgiSU5TRVJUIElOVE8g dGVzdCAobnVtYmVyKSBWQUxVRVMgKDApIikNCiAgICBwbHB5Lndhcm5pbmcoVEQpICMgTE9HIDIN CiAgICByZXR1cm4gTm9uZQ0KJEJPRFkkIExBTkdVQUdFICdwbHB5dGhvbjN1JzsNCg0KQ1JFQVRF IE9SIFJFUExBQ0UgVFJJR0dFUiB0cmVlZ2VyDQogIEFGVEVSIFVQREFURQ0KICBPTiB0ZXN0IEZP UiBFQUNIIFJPVw0KICBFWEVDVVRFIFBST0NFRFVSRSB0cmVlZ2VyKCk7DQotLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQpUaGVuIGV4ZWN1dGUgYW4gdXBk YXRlIGxpa2UgYmVsb3cgeW91IHdpbGwgc2VlIHRoYXQgdGhlIHRyaWdnZXIgZGF0YSBpcyB0aGUK c2FtZSBmb3IgTE9HIDEgYW5kIExPRyAyOw0KYFVQREFURSB0ZXN0IFNFVCBkb2l0PXRydWUgV0hF UkUgaWQ9MTtgDQoNClRoZXJlIGFyZSB0d28gd2F5cyB0byBhbHRlciB0aGUgdHJpZ2dlciB0aGF0 IHdpbGwgY2F1c2UgdGhlIFREIHRvIGJlCmRpZmZlcmVudCBmb3IgTE9HIDEgYW5kIExPRyAyLg0K RWl0aGVyIGFkZCBgT1IgSU5TRVJUYCBsaWtlIHRoaXM7DQoNCkNSRUFURSBPUiBSRVBMQUNFIFRS SUdHRVIgdHJlZWdlcg0KICBBRlRFUiBVUERBVEUgT1IgSU5TRVJUDQogIE9OIHRlc3QgRk9SIEVB Q0ggUk9XDQogIEVYRUNVVEUgUFJPQ0VEVVJFIHRyZWVnZXIoKTsNCg0Kb3IgYWRkIGEgY29uZGl0 aW9uIGxpa2UgdGhpczoNCkNSRUFURSBPUiBSRVBMQUNFIFRSSUdHRVIgdHJlZWdlcg0KICBBRlRF UiBVUERBVEUNCiAgT04gdGVzdCBGT1IgRUFDSCBST1cgV0hFTiAoTkVXLmRvaXQpDQogIEVYRUNV VEUgUFJPQ0VEVVJFIHRyZWVnZXIoKTsNCg0KVGhlbiBleGVjdXRlIHRoaXMgYWdhaW46DQpgVVBE QVRFIHRlc3QgU0VUIGRvaXQ9dHJ1ZSBXSEVSRSBpZD0xO2ANCg0KVGhlbiB0aGUgdHJpZ2dlciBk YXRhIGNoYW5nZXMgYWZ0ZXIgdGhlIGluc2VydCBzdGF0ZW1lbnQgaW4gdGhlIHRyaWdnZXIKZnVu Y3Rpb24uDQoNClRoYW5rcyBpbiBhZHZhbmNlLgoK --===============5638809168788147464==--