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 1uFBhx-001Fr0-5z for pgsql-bugs@arkaria.postgresql.org; Wed, 14 May 2025 12:59:37 +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 1uFBhw-009rjD-6t for pgsql-bugs@arkaria.postgresql.org; Wed, 14 May 2025 12:59:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uFBNA-009oY3-Jv for pgsql-bugs@lists.postgresql.org; Wed, 14 May 2025 12:38:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uFBN7-001rLe-1j for pgsql-bugs@lists.postgresql.org; Wed, 14 May 2025 12:38: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=DbB3aaYaeNfqNBZaLiokN4AlXaNTW+p82/M3lM/Ohzg=; b=zZuzr6+kLdvY4ZR40WQsm6LsDG pu+64+ckgsqfQO+QYpHVdsKxipBIIGOBX8+B0STybpkAyJPEnmzlHcLJs2iFg5qcXpAaBbHoDYFAz 3wz+tGCCreBzrnOH4ASYJhlkp9TSEFyEYbVsZfxsRp8VDWT0cjFm/vOykHTC1M8053HBSRPFrfHgz cDDQNHP9XohFgthxzhvucAPPuKCvNxGADlJ6M97+RkeTg2kW4BuDDz+haxlhSSgF/X/jXMOITcicF /eHkaacbXe/BiwLr3wg0+vs+4rt+bUeEY3F3hSOvb3BFsMLova1rvVv3D49kcjV3FfxqfCJ9QTb6F S6vSPQtQ==; 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 1uFBN6-0050O9-2D for pgsql-bugs@lists.postgresql.org; Wed, 14 May 2025 12: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 1uFBN5-003m0N-2k for pgsql-bugs@lists.postgresql.org; Wed, 14 May 2025 12:38:03 +0000 Content-Type: multipart/mixed; boundary="===============0195350308596534771==" MIME-Version: 1.0 Subject: BUG #18928: postgres_fdw search_path not reset causing pgbouncer pool_mode=transaction using the wrong schema To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jackie.space@gmail.com Reply-To: jackie.space@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 14 May 2025 12:37:36 +0000 Message-ID: <18928-b85f8c68121fd98b@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 --===============0195350308596534771== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkyOApMb2dnZWQgYnk6ICAgICAgICAgIEphY2tpZSBMaQpFbWFpbCBh ZGRyZXNzOiAgICAgIGphY2tpZS5zcGFjZUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ny41Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgsIE1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAg CgpJIGZpbGVkIGFuIGlzc3VlIHRvIHBnYm91bmNlciwgYnV0IEkgcmVhbGlzZWQgdGhlIGlzc3Vl IGlzIG1vcmUgcmVsYXRlZCB0bwpwb3N0Z3Jlc19mZHcgZXh0ZW5zaW9uOiBodHRwczovL2dpdGh1 Yi5jb20vcGdib3VuY2VyL3BnYm91bmNlci9pc3N1ZXMvMTMxMwpUbyByZXByb2R1Y2UgdGhpcyBp c3N1ZSwgeW91IGNhbiB1c2UgYSBtaW5pbWFsIGNvZGUgc2FtcGxlIGF0Cmh0dHBzOi8vZ2l0aHVi LmNvbS9qYWNraWVsaWkvcGdib3VuY2VyLWZkdy1pc3N1ZS90cmVlL21haW4KU3RlcHMgdG8gcmVw cm9kdWNlOgoxLiBzZXQgdXAgMiBkYXRhYmFzZXM6IGRiMSBhbmQgZGIyCjIuIHNldHVwIHBnYm91 bmNlciB0aGF0IGNvbm5lY3RzIHRvIGJvdGggaW4gdHJhbnNhY3Rpb24gcG9vbGluZyBtb2RlLiBT ZWUKW3BnYm91bmNlci5pbmldKGh0dHBzOi8vZ2l0aHViLmNvbS9qYWNraWVsaWkvcGdib3VuY2Vy LWZkdy1pc3N1ZS9ibG9iL21haW4vcGdib3VuY2VyLmluaSkKMy4gY29ubmVjdCB0byBkYjIgdmlh IHBnYm91bmNlciBhbmQgY3JlYXRlcyBmb3JlaWduIHNjaGVtYSBjb25uZWN0cyB0byBkYjEKdXNp bmcgcG9zdGdyZXNfZmR3CjQuIE5vdyBvcGVuIGEgY29ubmVjdGlvbiB0byBkYjEgdmlhIHBnYm91 bmNlciBhbmQgcnVuIHNlbGVjdCBxdWVyeSB3aXRob3V0CnNjaGVtYQo1LiBvYnNlcnZlIGFuIGVy cm9yIG9jY3VycyBiZWNhdXNlIHdyb25nIGRlZmF1bHQgc2NoZW1hIHBnX2NhdGFsb2cgaXMgdXNl ZDoKcmVsYXRpb24gInRlc3QxIiBkb2VzIG5vdCBleGlzdApUaGUgaXNzdWUgc2VlbXMgdG8gYmUg cmVsYXRlZCB0byBhIGNvbm5lY3Rpb24gc2V0cyB0aGUgc2VhcmNoX3BhdGggZ2V0cwpyZXVzZWQg YW5kIHNlYXJjaF9wYXRoIGlzIG5vdCByZXZlcnRlZDogW3JlbGF0ZWQgY29kZSBpbgpwb3N0Z3Jl c19mZHddKGh0dHBzOi8vZ2l0aHViLmNvbS9wb3N0Z3Jlcy9wb3N0Z3Jlcy9ibG9iL21hc3Rlci9j b250cmliL3Bvc3RncmVzX2Zkdy9wb3N0Z3Jlc19mZHcuYyNMMzkzNS1MMzkzOCkKSSBrbm93IHRo aXMgZmVlbHMgbGlrZSB3b3JraW5nIGFzIGludGVuZGVkIGFzIHBvc3RncmVzX2ZkdyBkb2VzIGNs b3NlIGFuZApyZXNldCBpdCBhdApodHRwczovL2dpdGh1Yi5jb20vcG9zdGdyZXMvcG9zdGdyZXMv YmxvYi9tYXN0ZXIvY29udHJpYi9wb3N0Z3Jlc19mZHcvcG9zdGdyZXNfZmR3LmMjTDM5NDYsCmJ1 dCBJIHRoaW5rIGl0IHNob3VsZCByZXZlcnQgdGhlIGBzZXRfY29uZmlnX29wdGlvbmAgZWZmZWN0 LCBlc3BlY2lhbGx5IGZvcgpzZWFyY2hfcGF0aApLaW5kIFJlZ2FyZHMsCkphY2tpZQoK --===============0195350308596534771==--