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 1tpy6S-00Ewe9-5v for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Mar 2025 23:24:40 +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 1tpy6Q-008l5v-Nm for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Mar 2025 23:24:38 +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 1tpy6Q-008l4x-9C for pgsql-hackers@lists.postgresql.org; Wed, 05 Mar 2025 23:24:38 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tpy6M-001Bmd-1Y for pgsql-hackers@postgresql.org; Wed, 05 Mar 2025 23:24:37 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-22349bb8605so309545ad.0 for ; Wed, 05 Mar 2025 15:24:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1741217073; x=1741821873; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=ZRxCXHt2abeMANGF6I+9Tiru7VSu66fMYapmCqQYR2w=; b=jhzQIWzDN0+fqIQ/NQqHAI/Fq6qg1T31jZSXSymHy2MMF+Nyiq7BvclAIJdvN+7dQn hs0e399pyiavzfCy3SQMu4gWG7IO3dDApzECJ1hv7bWPcxYMtlLmn3Xpr952hybvbolD Xy+pyhUDVqKCKD8zL49PZedA8Dp9J+q/8nfOWuUyerpKZwi1z9ksvu9/DkxS7WdX2gpd r/dT5h/oqt35DFo4jgoHWDczvPxG1McY4iRbSBqCJ0GH7gyns30Djcv6NeiQwFz6l3P0 w+txe5ffWO8Jyp1k0Sj5s5uy58C0+q2qWLvgAHFfsND/xk2WCge6dL0TQZL1zTKdSXQY AmTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741217073; x=1741821873; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ZRxCXHt2abeMANGF6I+9Tiru7VSu66fMYapmCqQYR2w=; b=nVUVbDGDFwetXWh7+jH4E7IiYymWfVg14gd4dFZa4cCDdxAKtJemdgEPSOO7L7ynJ7 bbJpiZfpKx4MUfJWx40kAYO1/pI+Me5ZKnlxeENOf4ltqdliQw0ZPJY6/aXcC8ZSuJo1 piIdcrnJdbK9REOrURMAvDwBAsyqf//flL1+or6DA9iLRRp7mJmGAZoGxeuCFEVsnkXD CfbIqqbUnuCZetzqoL7KZUVlmuGD6whL3rPuCV5qiolTuXQG4nv/ahaYEsi4xfVHFwvc qlNJPm+jpgQWKfirGqwyNPJeFSqwEGPaF9MTrEpS559i8kctLsIeIjx72UPPGIzB4Ha2 9rLw== X-Forwarded-Encrypted: i=1; AJvYcCU7OulrsDFn1A7XSpDjjaqKxJKjkTwXONC87X4Wretn3laB4wVPRJgpmsPOZ4FOLu09QAxZRS6VZC4IFwW9@postgresql.org X-Gm-Message-State: AOJu0YwxjP40nKmmnX1TSF/SbfCv/kZmkmFte49JbyjHlpEtur/41won fpFptJ4olT3HrFz1VidA7rLoWS6Xhw5oI0xBYXOyqujTeKqgUzxy24K9IJNoZQ== X-Gm-Gg: ASbGnctSRlR+r60whOfRP5zNx1wB+MzMy2DsjuXmdERuIbrfuVFtT2gup6SN2vN/OA2 KohDp81K50XPzu9pVckIqDIbQgx3EvchNNtg78MmB7fv+6dA+V5Op+bYTi7wibifD6lRC7VU+12 TGh0AmNfhopjc5moeOOxy557V5f7cWczCLvvrcU87Oa+GgddVEuCcpMP8x2Z7ogiV+IxLXV8dQd MTwWYQVQqQ17n2C/eo2hJiNgtZ72RsM6p5EvWono/AssrnE+CBtoEsipxebwzO3zDemTRXIJ+HN /td7x3OQuIHzpK+GKpA+GzdQZpxAWJAKR9YPUy+foBHaQ4WnwtNPvKyn2CJCKoPZq/jnGPBQjRY 99AJ1uNV5QNE= X-Google-Smtp-Source: AGHT+IF5jduhIoPWU/gGmYurmf8kauOIXsQqTi2A1xa0ikCIQSrScP6PGQggtK4SEimKgaYd0Vxc2g== X-Received: by 2002:a17:902:db02:b0:215:8d49:e2a7 with SMTP id d9443c01a7336-223f1d23875mr77283395ad.50.1741217073519; Wed, 05 Mar 2025 15:24:33 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-223f5a4105csm17843835ad.249.2025.03.05.15.24.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Mar 2025 15:24:33 -0800 (PST) Message-ID: Subject: Re: explain plans for foreign servers From: Jeff Davis To: Tom Lane Cc: Sami Imseih , dinesh salve , pgsql-hackers@postgresql.org Date: Wed, 05 Mar 2025 15:24:31 -0800 In-Reply-To: <341357.1741201933@sss.pgh.pa.us> References: <07147023882ac6c4424df946fd4b82b8e8c211a5.camel@j-davis.com> <341357.1741201933@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-03-05 at 14:12 -0500, Tom Lane wrote: > I'm afraid not.=C2=A0 That pretty fundamentally breaks the wire protocol, > I think. The extended protocol docs say: "The possible responses to Execute are the same as those described above for queries issued via simple query protocol, except that Execute doesn't cause ReadyForQuery or RowDescription to be issued." Each result set needs a RowDescription, so I think you're right that it breaks the extended protocol. I missed that the first time. Regards, Jeff Davis