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 1sUfCB-004hOP-DH for pgsql-committers@arkaria.postgresql.org; Fri, 19 Jul 2024 04:26:15 +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 1sUfC9-008rqH-IC for pgsql-committers@arkaria.postgresql.org; Fri, 19 Jul 2024 04:26:13 +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 1sUfAY-008q0b-6R for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 04:24:34 +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 1sUfAT-000J9n-UK for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 04:24:33 +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=NpIDTP5ylmp/hZk65dwKH3qVZuDWaj13Po4lAqZ3YzU=; b=SvhlNR9WfxapmXhHQEv9x8bXec bgdLVlDMN108hBBvSUWR0tBxHN0MaKObG8/26wQ2N+1mOS1WLiZXiJAPYoyEcCViY4TTdYkR2LLfb NVFjOeCJGfWKayYa6emA0KUwopwsSwRGJ1fPn/Bm/5IrgtDrjZ5SBba+YSgEk9GIK8TwlNQSCrAJ2 YGGHGjJPgm5xKCni9clDLIjqVSvo/vKaOmzhC75JTfE5haIzI0qr93KYbXH9eBekKuKlnG+HCHPP0 DSTblmPhoQyoX89e3uspFZkQTF+4mRfv8bKXZPOjy+CPFSOFp1DtX5kNzGBudiNN0RsFifQsAMDIE meVNJR3w==; 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.94.2) (envelope-from ) id 1sUfAT-000u3B-92 for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 04:24:29 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUfAS-000DnV-Jd for pgsql-committers@lists.postgresql.org; Fri, 19 Jul 2024 04:24:28 +0000 Content-Type: multipart/mixed; boundary="===============6085122515248331827==" MIME-Version: 1.0 From: Etsuro Fujita To: pgsql-committers@lists.postgresql.org Subject: pgsql: postgres_fdw: Avoid "cursor can only scan forward" error. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 19 Jul 2024 04:24:28 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6085122515248331827== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 cG9zdGdyZXNfZmR3OiBBdm9pZCAiY3Vyc29yIGNhbiBvbmx5IHNjYW4gZm9yd2FyZCIgZXJyb3Iu CgpDb21taXQgZDg0NGNkNzVhIGRpc2FsbG93ZWQgcmV3aW5kIGluIGEgbm9uLXNjcm9sbGFibGUg Y3Vyc29yIHRvIHJlc29sdmUKYW5vbWFsaWVzIGFyaXNpbmcgZnJvbSBzdWNoIGEgY3Vyc29yIG9w ZXJhdGlvbi4gIEhvd2V2ZXIsIHRoaXMgZmFpbGVkIHRvCnRha2UgaW50byBhY2NvdW50IHRoZSBh c3N1bXB0aW9uIGluIHBvc3RncmVzX2ZkdyB0aGF0IHdoZW4gcmVzY2FubmluZyBhCmZvcmVpZ24g cmVsYXRpb24sIGl0IGNhbiByZXdpbmQgdGhlIGN1cnNvciBjcmVhdGVkIGZvciBzY2FubmluZyB0 aGUKZm9yZWlnbiByZWxhdGlvbiB3aXRob3V0IHNwZWNpZnlpbmcgdGhlIFNDUk9MTCBvcHRpb24s IHJlZ2FyZGxlc3Mgb2YgaXRzCnNjcm9sbGFiaWxpdHksIGNhdXNpbmcgdGhpcyBlcnJvciB3aGVu IGl0IHRyaWVkIHRvIGRvIHN1Y2ggYSByZXdpbmQgaW4gYQpub24tc2Nyb2xsYWJsZSBjdXJzb3Iu ICBGaXggYnkgbW9kaWZ5aW5nIHBvc3RncmVzX2ZkdyB0byBpbnN0ZWFkCnJlY3JlYXRlIHRoZSBj dXJzb3IsIHJlZ2FyZGxlc3Mgb2YgaXRzIHNjcm9sbGFiaWxpdHksIHdoZW4gcmVzY2FubmluZwp0 aGUgZm9yZWlnbiByZWxhdGlvbi4gIChJZiB3ZSBoYWQgYSB3YXkgdG8gY2hlY2sgaXRzIHNjcm9s bGFiaWxpdHksIHdlCmNvdWxkIGltcHJvdmUgdGhpcyBieSByZXdpbmRpbmcgaXQgaWYgaXQgaXMg c2Nyb2xsYWJsZSBhbmQgcmVjcmVhdGluZyBpdAppZiBub3QsIGJ1dCB3ZSBkbyBub3QgaGF2ZSBp dCwgc28gdGhpcyBjb21taXQgbW9kaWZpZXMgaXQgdG8gcmVjcmVhdGUgaXQKaW4gYW55IGNhc2Uu KQoKUGVyIGJ1ZyAjMTc4ODkgZnJvbSBFcmljIEN5ci4gIERldnJpbSBHdW5kdXogYWxzbyByZXBv cnRlZCB0aGlzIHByb2JsZW0uCkJhY2stcGF0Y2ggdG8gdjE1IHdoZXJlIHRoYXQgY29tbWl0IGVu Zm9yY2VkIHRoZSBwcm9oaWJpdGlvbi4KClJldmlld2VkIGJ5IFRvbSBMYW5lLgoKRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNzg4OS1lOGMzOWEyNTFkMjU4ZGRhJTQwcG9zdGdyZXNx bC5vcmcKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9iNDE1YWMzMjU1ZjgzNTJkMWVh OTIxY2YzYjdiYTM5ZTA1ODc3NjhhLmNhbWVsJTQwZ3VuZHV6Lm9yZwoKQnJhbmNoCi0tLS0tLQpS RUxfMTZfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcv cGcvY29tbWl0ZGlmZi9kOTdmMmVlNTBlNDkwNDZhOTg0NjY1ZmI3MmZhMTRhMDZiZDU4NDM1CgpN b2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250cmliL3Bvc3RncmVzX2Zkdy9leHBlY3Rl ZC9wb3N0Z3Jlc19mZHcub3V0IHwgNDUgKysrKysrKysrKysrKysrKysrKysrKysrKysKY29udHJp Yi9wb3N0Z3Jlc19mZHcvcG9zdGdyZXNfZmR3LmMgICAgICAgICAgICB8IDIwICsrKysrKysrKy0t LQpjb250cmliL3Bvc3RncmVzX2Zkdy9zcWwvcG9zdGdyZXNfZmR3LnNxbCAgICAgIHwgMjUgKysr KysrKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA4NSBpbnNlcnRpb25zKCspLCA1IGRlbGV0aW9u cygtKQoK --===============6085122515248331827==--