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 1lHb8j-0001gi-JD for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 23:42:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHb8i-0006wp-Ey for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Mar 2021 23:42:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHb8i-0006wh-7z for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 23:42:48 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHb8g-0004Dn-Cj for pgsql-hackers@lists.postgresql.org; Wed, 03 Mar 2021 23:42:47 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id B98C45C0113; Wed, 3 Mar 2021 18:42:44 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 03 Mar 2021 18:42:44 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=P1rkEDWqD6Gj1mqpGtr3W9Lqye8eDm0DopQjRgpuW/s=; b=XZtzvja5 iZXK7IShH2qjAhWNGGKAoHqxZBXIM3NUv6Cxy5NK5H56L6zAPp+IlfA/Pdb1rPNC YgHzNBrI/CLkuLtdA+VLFIO08I3DKl+TfBfB8H+gsMLu+Mr8VGp8c1asbYvfyheu 0DilRRwjhkjDnzxz/FpE0+SbavONFRFxTEAWHyLuSC268tJ5lQv7syBOOA8wYbF1 dqgg49ZSD0KgfRz63hOSG0oHzUIqimV0qr8ezs6ErNUJ4H4bKjEXKkA9Dz3rBoEf nxJiHOs5MytmDxR0hHlPCNnGHKcNcIbljCjaBolfV8OF5wXPz50LdlcRYw0KkANY OJAwXJhW8uiUOw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledruddtfedguddtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjfgesthekredttderudenucfhrhhomhepkdetlhhv rghrohcujfgvrhhrvghrrgdkuceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdroh hrgheqnecuggftrfgrthhtvghrnhepgfdvvedvteeiheevgfeltdetgffghfeghedvleeh vdetiedthffgjeegkeekjeeknecukfhppeduledtrdelhedrudelrdelheenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges rghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA id 0FCCA24005A; Wed, 3 Mar 2021 18:42:44 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 646B32A14F6; Wed, 3 Mar 2021 20:42:41 -0300 (-03) Date: Wed, 3 Mar 2021 20:42:41 -0300 From: 'Alvaro Herrera' To: "k.jamison@fujitsu.com" Cc: Craig Ringer , Matthieu Garrigues , PostgreSQL-development Subject: Re: PATCH: Batch/pipelining support for libpq Message-ID: <20210303234241.GA22679@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210303163430.GA24777@alvherre.pgsql> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Mar-03, 'Alvaro Herrera' wrote: > I'm much more comfortable with this version, so I'm marking the patch as > Ready for Committer in case anybody else wants to look at this before I > push it. Actually, I just noticed a pretty serious problem, which is that when we report an error, we don't set "conn->errQuery" to the current query but to the *previous* query, leading to non-sensical error reports like $ ./pipeline pipeline_abort aborted pipeline... ERROR: no existe la función no_such_function(integer) LINE 1: INSERT INTO pq_pipeline_demo(itemno) VALUES ($1); ^ HINT: Ninguna función coincide en el nombre y tipos de argumentos. Puede ser necesario agregar conversión explícita de tipos. ok (Sorry about the Spanish there, but the gist of the problem is that we're positioning the error cursor on a query that succeeded prior to the query that raised the error.) This should obviously not occur. I'm trying to figure out how to repair it and not break everything again ... -- Álvaro Herrera Valdivia, Chile