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.96) (envelope-from ) id 1wwdrQ-0026hP-12 for pgsql-committers@arkaria.postgresql.org; Wed, 19 Aug 2026 10:49:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wwdrP-00396Y-0J for pgsql-committers@arkaria.postgresql.org; Wed, 19 Aug 2026 10:49:31 +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.96) (envelope-from ) id 1wwdrO-00396Q-2Q for pgsql-committers@lists.postgresql.org; Wed, 19 Aug 2026 10:49:30 +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.98.2) (envelope-from ) id 1wwdrL-000000006lH-489c for pgsql-committers@lists.postgresql.org; Wed, 19 Aug 2026 10:49:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=373dT4Xj3RSzAMfJWEhR2/qL6WdvtAntaRYWvM7pfa0=; b=q+QiGAyEjrzxCYDKtsg3vqkZj0 UMldgKaLkKA/plxHfq5AVNG3nfEzFrRVkdtlLedXXnNz+VJRn+5huGZLFPa8uV25R/psxR4M1hGLn 40VBiFZSFlP7PQhNbTINRoYka9QzlBa8Dhj6c4V78KDkttKjLjtoAZUUF5XbyfpXnxRfUcLAqY1WW U6rOBkxMTBJRxR6k68KCQYwPY4UB2AUrxgCtmk7kfF6ycfFerFvAOp5NCbP5xgsHlklypU60+mr+o apZbxaFUxyMY8ElAhWQorY24E6MWJMnBXYI2tm+7LjcxCvFRWG7mydM/c+ruHK1oaWz1kI3BMPKES gH12NliQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wwdrK-004Cwa-2Y for pgsql-committers@lists.postgresql.org; Wed, 19 Aug 2026 10:49:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1wwdrI-00000001CbA-30di for pgsql-committers@lists.postgresql.org; Wed, 19 Aug 2026 10:49:25 +0000 Content-Type: multipart/mixed; boundary="===============2931978372038005566==" MIME-Version: 1.0 From: Alexander Korotkov To: pgsql-committers@lists.postgresql.org Subject: pgsql: postgres_fdw: push down FUNCTION RTE into foreign joins X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 19 Aug 2026 10:49:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2931978372038005566== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cG9zdGdyZXNfZmR3OiBwdXNoIGRvd24gRlVOQ1RJT04gUlRFIGludG8gZm9yZWlnbiBqb2lucwoK QSBmb3JlaWduIGpvaW4gcGxhbm5pbmcgaG9vayBub3cgY29uc2lkZXJzIGEgKGZvcmVpZ24tdGFi bGUgeCBmdW5jdGlvbi1SVEUpCklOTkVSIGpvaW4gYXMgYSBwdXNoLWRvd24gY2FuZGlkYXRlIHdo ZW4gdGhlIGZ1bmN0aW9uIGV4cHJlc3Npb24gaXMKSU1NVVRBQkxFIGFuZCBvdGhlcndpc2Ugc2hp cHBhYmxlLiAgVGhlIHJlbW90ZSBxdWVyeSBhYnNvcmJzIHRoZSBmdW5jdGlvbgpjYWxsIGFzIGEg RlJPTS1saXN0IGl0ZW0gKGUuZy4gdW5uZXN0KC4uLikgQVMgZjxydGk+KGMxLCBjMiwgLi4uKSks IHNvIHRoZQpmb3JlaWduIHNpZGUgcmV0dXJucyBvbmx5IHJvd3MgdGhhdCBtYXRjaCB0aGUgZnVu Y3Rpb24tcHJvZHVjZWQgc2V0IGFuZCB0aGUKam9pbiBleGVjdXRlcyBlbnRpcmVseSBvbiB0aGUg cmVtb3RlLgoKQW4gSU1NVVRBQkxFIGZ1bmN0aW9uIGdpdmVzIHRoZSBzYW1lIHJlc3VsdCBvbiBh bnkgc2VydmVyLCBzbyB0aGUgc2FtZQpmdW5jdGlvbiBSVEUgY2FuIGJlIGEgcHVzaC1kb3duIGNh bmRpZGF0ZSBmb3Igc2V2ZXJhbCBkaXN0aW5jdCBmb3JlaWduCnNlcnZlcnMgd2l0aG91dCBzZW1h bnRpYyByaXNrLiAgVG8ga2VlcCB0aGUgcGxhbm5lciBzdGF0ZSBjb25zaXN0ZW50CmFjcm9zcyB0 aG9zZSBpbmRlcGVuZGVudCBhdHRlbXB0cywgdGhlIHBlci1jYWxsIHN0dWIgZnBpbmZvIGZvciB0 aGUKZnVuY3Rpb24gc2lkZSBsaXZlcyBvbiB0aGUgam9pbnJlbCdzIFBnRmR3UmVsYXRpb25JbmZv IChuZXcKb3V0ZXJfZnVuY19mcGluZm8gLyBpbm5lcl9mdW5jX2ZwaW5mbyksIG5ldmVyIG9uIHRo ZSBmdW5jdGlvbiByZWwgaXRzZWxmLAphbmQgdGhlIGZ1bmN0aW9uIHNpZGUgaXMgZGV0ZWN0ZWQg dmlhIHJ0ZWtpbmQgcmF0aGVyIHRoYW4gZmR3X3ByaXZhdGUuCgpzZXRfZm9yZWlnbl9yZWxfcHJv cGVydGllcygpIHByb3BhZ2F0ZXMgZmR3cm91dGluZSBvbnRvIGEgam9pbnJlbCB0aGF0CnBhaXJz IGEgZm9yZWlnbiByZWwgd2l0aCBhbiBSVEVfRlVOQ1RJT04gcmVsIHNvIEdldEZvcmVpZ25Kb2lu UGF0aHMgZ2V0cwpjYWxsZWQ7IHRoZSBGRFcgcmV0YWlucyBmdWxsIGNvbnRyb2wgb3ZlciB3aGV0 aGVyIHRvIGFjdHVhbGx5IGdlbmVyYXRlIGEKcGF0aC4gIGRlcGFyc2VSYW5nZVRibFJlZiBhbmQg ZGVwYXJzZUNvbHVtblJlZiBnYWluIGEgRlVOQ1RJT04tUlRFIGJyYW5jaAp0aGF0IGVtaXRzIHRo ZSBmdW5jdGlvbiBleHByZXNzaW9uIGFuZCByZXNvbHZlcyBWYXJzIHRvIHRoZSBnZW5lcmF0ZWQK Y29sdW1uIGFsaWFzZXMuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2UzYWY1NmY5 YjJmMWJkOWZkZjEyYWZmNmNhMjViMThkJTQwcG9zdGdyZXNwcm8ucnUKQXV0aG9yOiBBbGV4YW5k ZXIgUHloYWxvdiA8YS5weWhhbG92QHBvc3RncmVzcHJvLnJ1PgpSZXZpZXdlZC1ieTogU29sYWlt dXJ1Z2FuIFZlbGxhaXBhbmRpeWFuIDxkcnNvbGFpbXVydWdhbi52QGdtYWlsLmNvbT4KUmV2aWV3 ZWQtYnk6IEFsZXhhbmRlciBLb3JvdGtvdiA8YWVrb3JvdGtvdkBnbWFpbC5jb20+CgpCcmFuY2gK LS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvMGVlODNkZDRhOTk0MDg4M2I1MjQxZmM5YzgwZmQyN2Y2M2YyZTQ3ZgoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZGVwYXJz ZS5jICAgICAgICAgICAgICAgICB8IDE1NyArKysrKy0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZXhw ZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCB8IDYyNyArKysrKysrKysrKysrKysrKysrKysrKysKY29u dHJpYi9wb3N0Z3Jlc19mZHcvcG9zdGdyZXNfZmR3LmMgICAgICAgICAgICB8IDY0MiArKysrKysr KysrKysrKysrKysrKysrKy0tCmNvbnRyaWIvcG9zdGdyZXNfZmR3L3Bvc3RncmVzX2Zkdy5oICAg ICAgICAgICAgfCAgMTIgKwpjb250cmliL3Bvc3RncmVzX2Zkdy9zcWwvcG9zdGdyZXNfZmR3LnNx bCAgICAgIHwgMjc0ICsrKysrKysrKysrCmRvYy9zcmMvc2dtbC9wb3N0Z3Jlcy1mZHcuc2dtbCAg ICAgICAgICAgICAgICAgfCAgMTggKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9yZWxub2Rl LmMgICAgICAgICAgIHwgIDI1ICsKNyBmaWxlcyBjaGFuZ2VkLCAxNjk4IGluc2VydGlvbnMoKyks IDU3IGRlbGV0aW9ucygtKQoK --===============2931978372038005566==--