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 1jhAvQ-0001LD-B6 for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Jun 2020 11:54:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jhAvP-00005N-9P for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Jun 2020 11:54:15 +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 1jhAAp-0002KZ-76 for pgsql-bugs@lists.postgresql.org; Fri, 05 Jun 2020 11:06:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jhAAk-000117-UP for pgsql-bugs@lists.postgresql.org; Fri, 05 Jun 2020 11:06:05 +0000 Content-Type: multipart/mixed; boundary="===============8976266518187261773==" MIME-Version: 1.0 Subject: BUG #16481: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fabio.vianello@salvagninigroup.com Reply-To: fabio.vianello@salvagninigroup.com, pgsql-bugs@lists.postgresql.org Date: Fri, 05 Jun 2020 11:05:14 +0000 Message-ID: <16481-8bbe054e7bc0cb3c@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8976266518187261773== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjQ4MQpMb2dnZWQgYnk6ICAgICAgICAgIEZhYmlvIFZpYW5lbGxvCkVt YWlsIGFkZHJlc3M6ICAgICAgZmFiaW8udmlhbmVsbG9Ac2FsdmFnbmluaWdyb3VwLmNvbQpQb3N0 Z3JlU1FMIHZlcnNpb246IDEyLjMKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDEwCkRlc2Ny aXB0aW9uOiAgICAgICAgCgpBYm91dCB0aGUgYnVnIEJVRyAjMTUyOTMsIG9uIFBvc3RncmVTUUwg dmVyc2lvbiAxMC40IGFuZCAxMS4yIGFzIGRlc2NyaWJlCmJlbG93LCB3ZSBmb3VuZCB0aGUgc2Ft ZSBpc3N1ZSBvbiB0aGUgUG9zdGdyZVNRTCB2ZXJzaW9uIDEyLjMuDQoNCkRvIHlvdSB0aGluayB0 byBzb2x2ZSB0aGUgaXNzdWU/DQoNCklzIGl0IGEgZmVhdHVyZT8gDQpCZWNhc3VlIGluIHRoZSBk b2N1bWVudGF0aW9uIHdlIGRpZG4ndCBmb3VuZCBhbnkgY29uc3RyYWludCB0aGF0IHNheXMgdGhh dAp3ZSBjYW4gbm90IHVzZSBOT1RJRlkvTElTVEVOIG9uIGxvZ2ljYWwgcmVwbGljYXRpb24gdGFi bGVzLg0KDQoiV2hlbiB1c2luZyBsb2dpY2FsIHJlcGxpY2F0aW9uIGEgc3RvcmVkIHByb2NlZHVy ZSBleGVjdXRlZCBvbiB0aGUgcmVwbGljYQppcw0KdW5hYmxlIHRvIHVzZSBOT1RJRlkgdG8gc2Vu ZCBtZXNzYWdlcyB0byBvdGhlciBsaXN0ZW5lcnMuIFRoZSBzdG9yZWQNCnByb2NlZHVyZSBkb2Vz IGV4ZWN1dGUgYXMgZXhwZWN0ZWQgYnV0IHRoZSBwZ19ub3RpZnkoKSBkb2Vzbid0IGFwcGVhciB0 bw0KaGF2ZSBhbnkgZWZmZWN0LiBJZiBhbiBpbnNlcnQgaXMgcnVuIG9uIHRoZSByZXBsaWNhIHNp ZGUgdGhlIHRyaWdnZXINCmV4ZWN1dGVzIHRoZSBzdG9yZWQgcHJvY2VkdXJlIGFzIGV4cGVjdGVk IGFuZCB0aGUgTk9USUZZIGNvcnJlY3RseQpub3RpZmllcw0KbGlzdGVuZXJzLg0KDQpTdGVwcyB0 byBSZXByb2R1Y2U6DQpTZXQgdXAgTWFzdGVyOg0KQ1JFQVRFIFRBQkxFIHRlc3QgKGlkIFNFUklB TCBQUklNQVJZIEtFWSwgbXNnIFRFWFQgTk9UIE5VTEwpOw0KQ1JFQVRFIFBVQkxJQ0FUSU9OIHRl c3RwdWIgRk9SIFRBQkxFIHRlc3Q7DQoNClNldCB1cCBSZXBsaWNhOg0KQ1JFQVRFIFRBQkxFIHRl c3QgKGlkIFNFUklBTCBQUklNQVJZIEtFWSwgbXNnIFRFWFQgTk9UIE5VTEwpOw0KQ1JFQVRFIFNV QlNDUklQVElPTiB0ZXN0c3ViIENPTk5FQ1RJT04gJ2hvc3Q9MTkyLjE2OC4wLjEzNiB1c2VyPXRl c3QNCnBhc3N3b3JkPXRlc3QnIFBVQkxJQ0FUSU9OIHRlc3RwdWI7DQpDUkVBVEUgT1IgUkVQTEFD RSBGVU5DVElPTiBub3RpZnlfY2hhbm5lbCgpIFJFVFVSTlMgdHJpZ2dlciBBUyAkJA0KQkVHSU4N ClJBSVNFIExPRyAnTm90aWZ5IFRyaWdnZXJlZCc7DQpQRVJGT1JNIHBnX25vdGlmeSgndGVzdGNo YW5uZWwnLCAnVGVzdGluZycpOw0KUkVUVVJOIE5FVzsNCkVORDsNCiQkIExBTkdVQUdFICdwbHBn c3FsJzsNCkRST1AgVFJJR0dFUiBxdWV1ZV9pbnNlcnQgT04gVEVTVDsNCkNSRUFURSBUUklHR0VS IHF1ZXVlX2luc2VydCBBRlRFUiBJTlNFUlQgT04gdGVzdCBGT1IgRUFDSCBST1cgRVhFQ1VURQ0K UFJPQ0VEVVJFIG5vdGlmeV9jaGFubmVsKCk7DQpBTFRFUiBUQUJMRSB0ZXN0IEVOQUJMRSBBTFdB WVMgVFJJR0dFUiBxdWV1ZV9pbnNlcnQ7DQpMSVNURU4gdGVzdGNoYW5uZWw7DQoNClJ1biB0aGUg Zm9sbG93aW5nIGluc2VydCBvbiB0aGUgbWFzdGVyOg0KSU5TRVJUIElOVE8gdGVzdCAobXNnKSBW QUxVRVMgKCd0ZXN0Jyk7DQoNCkluIHBvc3RncmVzcWwtMTAtbWFpbi5sb2cgSSBnZXQgdGhlIGZv bGxvd2luZzoNCjIwMTgtMDctMjQgMDc6NDU6MTUuNzA1IEVEVCBbNjcwMV0gTE9HOiAwMDAwMDog Tm90aWZ5IFRyaWdnZXJlZA0KMjAxOC0wNy0yNCAwNzo0NToxNS43MDUgRURUIFs2NzAxXSBDT05U RVhUOiBQTC9wZ1NRTCBmdW5jdGlvbg0Kbm90aWZ5X2NoYW5uZWwoKSBsaW5lIDMgYXQgUkFJU0UN CjIwMTgtMDctMjQgMDc6NDU6MTUuNzA1IEVEVCBbNjcwMV0gTE9DQVRJT046IGV4ZWNfc3RtdF9y YWlzZSwNCnBsX2V4ZWMuYzozMzM3DQoNCkJ1dCBubyBsaXN0ZW5lcnMgcmVjZWl2ZSB0aGUgbWVz c2FnZS4gSG93ZXZlciBpZiBhbiBpbnNlcnQgaXMgcnVuIGRpcmVjdGx5DQpvbiB0aGUgcmVwbGlj YToNCklOU0VSVCBJTlRPIHRlc3QgVkFMVUVTICg5OTk5OSwgJ3Rlc3QnKTsNCg0KSU5TRVJUIDAg MQ0KQXN5bmNocm9ub3VzIG5vdGlmaWNhdGlvbiAidGVzdGNoYW5uZWwiIHdpdGggcGF5bG9hZCAi VGVzdGluZyIgcmVjZWl2ZWQKZnJvbQ0Kc2VydmVyIHByb2Nlc3Mgd2l0aCBQSUQgNjcwMS4NCkFz eW5jaHJvbm91cyBub3RpZmljYXRpb24gInRlc3RjaGFubmVsIiB3aXRoIHBheWxvYWQgIlRlc3Rp bmciIHJlY2VpdmVkCmZyb20NCnNlcnZlciBwcm9jZXNzIHdpdGggUElEIDY3MDEuDQpBc3luY2hy b25vdXMgbm90aWZpY2F0aW9uICJ0ZXN0Y2hhbm5lbCIgd2l0aCBwYXlsb2FkICJUZXN0aW5nIiBy ZWNlaXZlZApmcm9tDQpzZXJ2ZXIgcHJvY2VzcyB3aXRoIFBJRCA2NzAxLg0KQXN5bmNocm9ub3Vz IG5vdGlmaWNhdGlvbiAidGVzdGNoYW5uZWwiIHdpdGggcGF5bG9hZCAiVGVzdGluZyIgcmVjZWl2 ZWQKZnJvbQ0Kc2VydmVyIHByb2Nlc3Mgd2l0aCBQSUQgNjcwMS4NCkFzeW5jaHJvbm91cyBub3Rp ZmljYXRpb24gInRlc3RjaGFubmVsIiB3aXRoIHBheWxvYWQgIlRlc3RpbmciIHJlY2VpdmVkCmZy b20NCnNlcnZlciBwcm9jZXNzIHdpdGggUElEIDY3MDEuDQpBc3luY2hyb25vdXMgbm90aWZpY2F0 aW9uICJ0ZXN0Y2hhbm5lbCIgd2l0aCBwYXlsb2FkICJUZXN0aW5nIiByZWNlaXZlZApmcm9tDQpz ZXJ2ZXIgcHJvY2VzcyB3aXRoIFBJRCA5OTkyLg0KDQpCYWNrZWQgdXAgbm90aWZpY2F0aW9ucyBh cmUgcmVjZWl2ZWQgZm9yIHByZXZpb3VzIE5PVElGWSdzLiIKCg== --===============8976266518187261773==--