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 1kaxCL-0007Qc-WC for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Nov 2020 08:34: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 1kaxCK-000331-01 for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Nov 2020 08:34:16 +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 1kasFS-0007V7-LI for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2020 03:17:10 +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 1kasFQ-0004tn-0q for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2020 03:17:10 +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=MHDiNqp1GgVaqBJ2kf2GM1V5VaFfPLOW3+dmtBAECCw=; b=mPr3K9mcG0yrbWJn7ASJy5GmtY ce//M/D9E+94eJNEP+5kCXaDRaX6ldF+BFLWh38d72eSIUWw94tLohbkBTsbld1wa+ipT3FpI+izt GNfYZpM8Dl3DPURU5oVndNXqv306F8+2KoT2twFMVd4lnyfHxp+dQBMWL70A9EE59cCjegzd6tUT7 +reHgjO20nsqb9HlHPabR+usSz8sfaxKZTEobvgf6kz4lhcrx+jRk88Uita76EhqF3xJ9bqMl8Bu2 ZVYPccP79+Hza8LXvRrJzhonsD7wULLp51E0TlQp7CaYi1/eOo57iCmuvALByLFXaLz638efRE12J Ty7uIdKA==; 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 1kasFO-0004Ie-Ih for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2020 03:17:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kasFK-0004DH-Ou for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2020 03:17:02 +0000 Content-Type: multipart/mixed; boundary="===============5464549334265777264==" MIME-Version: 1.0 Subject: BUG #16705: Triggers deferred during commit callback are not executed To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rbiro@interfacefinancial.com Reply-To: rbiro@interfacefinancial.com, pgsql-bugs@lists.postgresql.org Date: Fri, 06 Nov 2020 03:17:02 +0000 Message-ID: <16705-f34c72116d9b2174@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5464549334265777264== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjcwNQpMb2dnZWQgYnk6ICAgICAgICAgIFJvc3MgQmlybwpFbWFpbCBh ZGRyZXNzOiAgICAgIHJiaXJvQGludGVyZmFjZWZpbmFuY2lhbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMC4xMApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAg CgpJZiB5b3UgcmVnaXN0ZXIgYSBmdW5jdGlvbiB3aXRoIFJlZ2lzdGVyWGFjdENhbGxiYWNrIHRo YXQgY2F1c2VzIGEgdHJpZ2dlcgp0byBiZSBkZWZlcnJlZCwgdGhhdCB0cmlnZ2VyIGlzIG5ldmVy IGV4ZWN1dGVkLg0KDQpUaGUgY29kZSBpbiBDb21taXRUcmFuc2FjdGlvbjoNCg0KICAgICAvKg0K ICAgICAgKiBEbyBwcmUtY29tbWl0IHByb2Nlc3NpbmcgdGhhdCBpbnZvbHZlcyBjYWxsaW5nIHVz ZXItZGVmaW5lZCBjb2RlLApzdWNoDQogICAgICAqIGFzIHRyaWdnZXJzLiAgU2luY2UgY2xvc2lu ZyBjdXJzb3JzIGNvdWxkIHF1ZXVlIHRyaWdnZXIgYWN0aW9ucywNCiAgICAgICogdHJpZ2dlcnMg Y291bGQgb3BlbiBjdXJzb3JzLCBldGMsIHdlIGhhdmUgdG8ga2VlcCBsb29waW5nIHVudGlsCnRo ZXJlJ3MNCiAgICAgICogbm90aGluZyBsZWZ0IHRvIGRvLg0KICAgICAgKi8NCiAgICAgZm9yICg7 OykNCiAgICAgew0KICAgICAgICAgLyoNCiAgICAgICAgICAqIEZpcmUgYWxsIGN1cnJlbnRseSBw ZW5kaW5nIGRlZmVycmVkIHRyaWdnZXJzLg0KICAgICAgICAgICovDQogICAgICAgICBBZnRlclRy aWdnZXJGaXJlRGVmZXJyZWQoKTsNCiANCiAgICAgICAgIC8qDQogICAgICAgICAgKiBDbG9zZSBv cGVuIHBvcnRhbHMgKGNvbnZlcnRpbmcgaG9sZGFibGUgb25lcyBpbnRvIHN0YXRpYwpwb3J0YWxz KS4NCiAgICAgICAgICAqIElmIHRoZXJlIHdlcmVuJ3QgYW55LCB3ZSBhcmUgZG9uZSAuLi4gb3Ro ZXJ3aXNlIGxvb3AgYmFjayB0bwpjaGVjaw0KICAgICAgICAgICogaWYgdGhleSBxdWV1ZWQgZGVm ZXJyZWQgdHJpZ2dlcnMuICBMYXRoZXIsIHJpbnNlLCByZXBlYXQuDQogICAgICAgICAgKi8NCiAg ICAgICAgIGlmICghUHJlQ29tbWl0X1BvcnRhbHMoZmFsc2UpKQ0KICAgICAgICAgICAgIGJyZWFr Ow0KICAgICB9DQogDQogICAgIENhbGxYYWN0Q2FsbGJhY2tzKGlzX3BhcmFsbGVsX3dvcmtlciA/ IFhBQ1RfRVZFTlRfUEFSQUxMRUxfUFJFX0NPTU1JVA0KICAgICAgICAgICAgICAgICAgICAgICA6 IFhBQ1RfRVZFTlRfUFJFX0NPTU1JVCk7DQogDQogIA0KSXQgbWF5IGJlIHBvc3NpYmxlIHRvIGp1 c3QgbW92ZSBDYWxsWGFjdENhbGxiYWNrcyBpbnNpZGUgdGhlIGxvb3Agb3IgYWQgYQpzZWNvbmQg bG9vcCBhcm91bmQgdGhlIGV4aXN0aW5nIGxvb3AgYW5kIHRoZSBjYWxsYmFja3MuICBBbHRlcm5h dGl2ZWx5LApwZXJoYXBzIHRoZSByaWdodCBzb2x1dGlvbiBpcyB0byBkb2N1bWVudCB0aGF0IGNv bW1pdCBjYWxsYmFja3MgY2Fubm90IGRvCmFueXRoaW5nIHRoYXQgbWlnaHQgZGVmZXIgYSB0cmln Z2VyLCBvciBwcmV2ZW50IHRyaWdnZXJzIGZyb20gYmVpbmcgZGVmZXJyZWQKZm9yIHRoZSByZXN0 IG9mIHRoZSB0cmFuc2FjdGlvbnMuCgo= --===============5464549334265777264==--