Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8RPj-00018s-RN for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 19:39:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8RPi-0007qj-CR for pgsql-hackers@arkaria.postgresql.org; Thu, 22 Dec 2022 19:39:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8RPh-0007nr-Kn for pgsql-hackers@lists.postgresql.org; Thu, 22 Dec 2022 19:39:34 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8RPc-0007mU-6o for pgsql-hackers@postgresql.org; Thu, 22 Dec 2022 19:39:32 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 5086B320070D; Thu, 22 Dec 2022 14:39:25 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 22 Dec 2022 14:39:25 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1671737964; x=1671824364; bh=d FSq3oQMXggBf00/mamDAOLKyFtFDeKZQPriuiSz2mc=; b=Y5W8qJpnWtCHiSmwv Pz3xs4+DSQKpi1LYsiEoBf77A8BWBe2U5BKkqqWdEBjL3EaDsBTnbD/VSlJtW1OU vfgfpWPyNlxDHt3hEU3sgWSYD1S/xajeM+5+23AVbqyQW6xVemjSH3IIo3Nt5wtk zitvzqiP6iVnbc35T21bRy8JJGUcLyKM1ZjcxChoIXuJR8pFQfbwp/DXaaM9M8H8 GtZwytp/X9WsQBzEheKoEriinbE5qxKpupRu7LBzuIFFJCKssMcGOi4py/NuGunR MT0sTno7fU7fuA23wVsF7eOjxTJDLBdQN0zKLpseHfl3QVGxFIkQ9vmUT9Ok1S9w Wsi9w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrhedtgdduvdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffhjeejhffgieeuueekjeek fffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 22 Dec 2022 14:39:24 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 148ABE9A; Thu, 22 Dec 2022 20:39:21 +0100 (CET) Date: Thu, 22 Dec 2022 20:39:21 +0100 From: Alvaro Herrera To: Peter Eisentraut Cc: pgsql-hackers Subject: Re: dynamic result sets support in extended query protocol Message-ID: <20221222193921.yaosmvvoymncxyl2@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20221221194120.wttku6u7cbd6e574@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-Dec-21, Alvaro Herrera wrote: > I suppose that in order for this to work, we would have to find another > way to "advance" the queue that doesn't rely on the status being > PGASYNC_READY. I think the way to make this work is to increase the coupling between fe-exec.c and fe-protocol.c by making the queue advance occur when CommandComplete is received. This is likely more correct protocol-wise than what we're doing now: we would consider the command as done when the server tells us it is done, rather than relying on internal libpq state. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/