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 1sqTZE-00A1XB-E4 for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Sep 2024 08:28:13 +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 1sqTZD-007GjK-SY for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Sep 2024 08:28:11 +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 1sqQlx-004qxI-Ih for pgsql-bugs@lists.postgresql.org; Tue, 17 Sep 2024 05:29:09 +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 1sqQlu-001aUE-4F for pgsql-bugs@lists.postgresql.org; Tue, 17 Sep 2024 05:29:08 +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=HHkijUbJyAyL5zF6mcFzWxPsLD+r+n7Ot3KlgR0EJY0=; b=Ujo2HdQ8wLk2VDaH6kx/jQKqly F8pf0pDJP7aXlQFj7KIisFhi3hQ2vxCe8jV3iAMmAcbJzrmKpaNHtQCV3T9ERX7XgT+pmkHa7nPI0 n2GejCNLC9DhIXGDb/BIk1zOVv1jDkyJE88YlrxsWJV2CgRcYieI343WFch7DGbTA66x7Zth4DioT b2A2oE/ofzMw8Kc40JAcvrlpkOVbQIdw2gp8AO45ISKMEPGvh8DMNN1AcSweISYA44rEs7/9sAiqZ kvr+LctSDN6gQ8rgcr9wpxvqKxH0OML4buccY2y6tMU6in5JDRN2kWy8lrrC7jm9K3quqgosViS+Y u9WKL8mw==; 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 1sqQlt-0058kU-02 for pgsql-bugs@lists.postgresql.org; Tue, 17 Sep 2024 05:29:05 +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 1sqQlr-00BjVx-2C for pgsql-bugs@lists.postgresql.org; Tue, 17 Sep 2024 05:29:03 +0000 Content-Type: multipart/mixed; boundary="===============2440322455208999358==" MIME-Version: 1.0 Subject: BUG #18621: postgres_fdw cannot work with tables that use schemaless functions in triggers To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rekgrpth@gmail.com Reply-To: rekgrpth@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 17 Sep 2024 05:28:53 +0000 Message-ID: <18621-34e3fc574aa9fbc1@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 --===============2440322455208999358== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYyMQpMb2dnZWQgYnk6ICAgICAgICAgIFJla0dScHRoCkVtYWlsIGFk ZHJlc3M6ICAgICAgcmVrZ3JwdGhAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYuNApP cGVyYXRpbmcgc3lzdGVtOiAgIGRvY2tlciBhbHBpbmUKRGVzY3JpcHRpb246ICAgICAgICAKCkxl dCdzIGNyZWF0ZSBhIHRyaWdnZXIgb24gYSByZW1vdGUgc2VydmVyIHRoYXQgdXNlcyBkaWZmZXJl bnQgZnVuY3Rpb25zIGZvcgpkaWZmZXJlbnQgdXNlcnMuIHBvc3RncmVzX2ZkdyBjYW5ub3QgcGVy Zm9ybSBhbiBpbnNlcnQgaW4gdGhpcyBjYXNlLiBBbmQgdGhlCnJlbW90ZSBzZXJ2ZXIgbWF5IGJl IGEgcHJvZHVjdGlvbiBzZXJ2ZXIsIHdoZXJlIHRoZXJlIGlzIG5vIGFjY2VzcyB0byBjaGFuZ2UK dGhlIHRyaWdnZXIgY29kZSBzbyB0aGF0IGl0IHVzZXMgYW4gZXhwbGljaXQgc2NoZW1hIHNwZWNp ZmljYXRpb24hDQoNCmRyb3AgZGF0YWJhc2UgbG9jYWw7DQpkcm9wIGRhdGFiYXNlIHJlbW90ZTsN Cg0KZHJvcCB1c2VyIGFsaWNlOw0KZHJvcCB1c2VyIGJvYjsNCmRyb3AgdXNlciBsb2NhbDsNCmRy b3AgdXNlciByZW1vdGU7DQoNCmNyZWF0ZSB1c2VyIGFsaWNlIHN1cGVydXNlcjsNCmNyZWF0ZSB1 c2VyIGJvYiBzdXBlcnVzZXI7DQpjcmVhdGUgdXNlciBsb2NhbCBzdXBlcnVzZXI7DQpjcmVhdGUg dXNlciByZW1vdGUgc3VwZXJ1c2VyOw0KDQpjcmVhdGUgZGF0YWJhc2UgbG9jYWwgd2l0aCBvd25l ciBsb2NhbDsNCmNyZWF0ZSBkYXRhYmFzZSByZW1vdGUgd2l0aCBvd25lciByZW1vdGU7DQoNClxj b25uZWN0ICJ1c2VyPXJlbW90ZSBkYm5hbWU9cmVtb3RlIg0KY3JlYXRlIHRhYmxlIHJlbW90ZSAo aSBpbnQsIHQgdGV4dCk7DQpjcmVhdGUgc2NoZW1hIHJlbW90ZTsNCnRydW5jYXRlIHRhYmxlIHJl bW90ZTsNCmNyZWF0ZSBmdW5jdGlvbiBtdWx0aXBseShpIGludCkgcmV0dXJucyBpbnQgbGFuZ3Vh Z2UgcGxwZ3NxbCBhcyAkYm9keSQKYmVnaW4NCiAgICByZXR1cm4gaSAqIDE7DQplbmQ7JGJvZHkk Ow0KY3JlYXRlIHNjaGVtYSBhbGljZTsNCmNyZWF0ZSBmdW5jdGlvbiBhbGljZS5tdWx0aXBseShp IGludCkgcmV0dXJucyBpbnQgbGFuZ3VhZ2UgcGxwZ3NxbCBhcyAkYm9keSQKYmVnaW4NCiAgICBy ZXR1cm4gaSAqIDI7DQplbmQ7JGJvZHkkOw0KY3JlYXRlIHNjaGVtYSBib2I7DQpjcmVhdGUgZnVu Y3Rpb24gYm9iLm11bHRpcGx5KGkgaW50KSByZXR1cm5zIGludCBsYW5ndWFnZSBwbHBnc3FsIGFz ICRib2R5JApiZWdpbg0KICAgIHJldHVybiBpICogMzsNCmVuZDskYm9keSQ7DQpjcmVhdGUgZnVu Y3Rpb24gcmVtb3RlX3RyaWdnZXIoKSByZXR1cm5zIHRyaWdnZXIgbGFuZ3VhZ2UgcGxwZ3NxbCBh cyAkYm9keSQKYmVnaW4NCiAgICBpZiB0Z193aGVuID0gJ0JFRk9SRScgYW5kIHRnX29wIGluICgn SU5TRVJUJywgJ1VQREFURScpIHRoZW4NCiAgICAgICAgbmV3LmkgPSBtdWx0aXBseShuZXcuaSk7 DQogICAgICAgIG5ldy50ID0gY3VycmVudF91c2VyOw0KICAgIGVuZCBpZjsNCiAgICByZXR1cm4g Y2FzZSB3aGVuIHRnX29wID0gJ0RFTEVURScgdGhlbiBvbGQgZWxzZSBuZXcgZW5kOw0KZW5kOyRi b2R5JDsNCmNyZWF0ZSB0cmlnZ2VyIHJlbW90ZV9iZWZvcmVfdHJpZ2dlciBiZWZvcmUgaW5zZXJ0 IG9yIHVwZGF0ZSBvciBkZWxldGUgb24KcmVtb3RlIGZvciBlYWNoIHJvdyBleGVjdXRlIHByb2Nl ZHVyZSByZW1vdGVfdHJpZ2dlcigpOw0KY3JlYXRlIHRyaWdnZXIgcmVtb3RlX2FmdGVyX3RyaWdn ZXIgYWZ0ZXIgaW5zZXJ0IG9yIHVwZGF0ZSBvciBkZWxldGUgb24KcmVtb3RlIGZvciBlYWNoIHJv dyBleGVjdXRlIHByb2NlZHVyZSByZW1vdGVfdHJpZ2dlcigpOw0KaW5zZXJ0IGludG8gcmVtb3Rl IHNlbGVjdCAxOw0KDQpcY29ubmVjdCAidXNlcj1ib2IgZGJuYW1lPXJlbW90ZSINCmluc2VydCBp bnRvIHJlbW90ZSBzZWxlY3QgMTsNCg0KXGNvbm5lY3QgInVzZXI9YWxpY2UgZGJuYW1lPXJlbW90 ZSINCmluc2VydCBpbnRvIHJlbW90ZSBzZWxlY3QgMTsNCg0KXGNvbm5lY3QgInVzZXI9bG9jYWwg ZGJuYW1lPWxvY2FsIg0KY3JlYXRlIHNjaGVtYSBmZHc7DQpjcmVhdGUgZXh0ZW5zaW9uIHBvc3Rn cmVzX2ZkdyBzY2hlbWEgZmR3Ow0KY3JlYXRlIHNlcnZlciByZW1vdGUgZm9yZWlnbiBkYXRhIHdy YXBwZXIgcG9zdGdyZXNfZmR3IG9wdGlvbnMgKGRibmFtZQoncmVtb3RlJyk7DQpjcmVhdGUgdXNl ciBtYXBwaW5nIGZvciBjdXJyZW50X3VzZXIgc2VydmVyIHJlbW90ZSBvcHRpb25zICh1c2VyCidy ZW1vdGUnKTsNCmNyZWF0ZSB1c2VyIG1hcHBpbmcgZm9yIGFsaWNlIHNlcnZlciByZW1vdGUgb3B0 aW9ucyAodXNlciAncmVtb3RlJyk7DQpjcmVhdGUgdXNlciBtYXBwaW5nIGZvciBib2Igc2VydmVy IHJlbW90ZSBvcHRpb25zICh1c2VyICdyZW1vdGUnKTsNCmNyZWF0ZSBmb3JlaWduIHRhYmxlIHJl bW90ZSAoaSBpbnQsIHQgdGV4dCkgc2VydmVyIHJlbW90ZSBvcHRpb25zCihzY2hlbWFfbmFtZSAn cHVibGljJywgdGFibGVfbmFtZSAncmVtb3RlJyk7DQpzZWxlY3QgKiBmcm9tIHJlbW90ZTsNCg0K XGNvbm5lY3QgInVzZXI9Ym9iIGRibmFtZT1sb2NhbCINCmluc2VydCBpbnRvIHJlbW90ZSBzZWxl Y3QgaSBmcm9tIGdlbmVyYXRlX3NlcmllcygxLCAxMCkgaTsNCg0KRVJST1I6ICBmdW5jdGlvbiBt dWx0aXBseShpbnRlZ2VyKSBkb2VzIG5vdCBleGlzdA0KSElOVDogIE5vIGZ1bmN0aW9uIG1hdGNo ZXMgdGhlIGdpdmVuIG5hbWUgYW5kIGFyZ3VtZW50IHR5cGVzLiBZb3UgbWlnaHQgbmVlZAp0byBh ZGQgZXhwbGljaXQgdHlwZSBjYXN0cy4NCkNPTlRFWFQ6ICBQTC9wZ1NRTCBmdW5jdGlvbiByZW1v dGUucmVtb3RlX3RyaWdnZXIoKSBsaW5lIDMgYXQgYXNzaWdubWVudA0KcmVtb3RlIFNRTCBjb21t YW5kOiBJTlNFUlQgSU5UTyBwdWJsaWMucmVtb3RlKGksIHQpIFZBTFVFUyAoJDEsICQyKQoK --===============2440322455208999358==--