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 1t6gub-00ErB4-Gl for pgsql-committers@arkaria.postgresql.org; Fri, 01 Nov 2024 01:57:17 +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 1t6guY-0089tN-Uj for pgsql-committers@arkaria.postgresql.org; Fri, 01 Nov 2024 01:57:15 +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 1t6guY-0089tD-ND for pgsql-committers@lists.postgresql.org; Fri, 01 Nov 2024 01:57:15 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t6guS-0046R8-EE for pgsql-committers@lists.postgresql.org; Fri, 01 Nov 2024 01:57:14 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.phl.internal (Postfix) with ESMTP id AC1F91140180; Thu, 31 Oct 2024 21:57:06 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Thu, 31 Oct 2024 21:57:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1730426226; x=1730512626; bh=NMBf10qyD9 ZBsIjBVdwu3FezuGaDQSiwvBMKXzyqGiY=; b=QP60XVN2LTZPydo/HvFYgIUulg 7IlxUXbggOg3j1b7MukVo8H2lIny0RqX9UvVrVWFTRBpHnZw1qsdt6+iwGnp5Znc pPvEVUKjiCtqEgFzsGpILf+2AIRCVxkj5fehJ8cFBZysCAnVzyGynb85RwGRzp0w XvI8JrUumfBa7TJTuNNEl+xheAXbbIdXwBhYdewprQKxRkKoOMpn599VbepZfjWk NETefASj2F1OdXBRIJk95EKlXiKOaQgFpddyV0Kj3l8wTOBmrnj5wcrFdCD9o1/4 Q3TuSn+ozit+DCWaFRyA2HmkolO860HCFQulUB9Aj0Yw79UoZT7OvMvc39YA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1730426226; x=1730512626; bh=NMBf10qyD9ZBsIjBVdwu3FezuGaDQSiwvBM KXzyqGiY=; b=Te/mpffMlrjxU9OqJso0OYdMO4adqfTze0xRECpEjE6FBpgAGEH HDOQb/G9PBf8UKa+VRknZ95pYIUeHYielAzQ4ymJxdVGT1J06ROolpE+J50KF0oy QauicBmPEzNlKaxVF+oAKYalSW1rgeT1DmwG9BHxVVAsjoNWDlpb3ap8ZIhc4L7L D/U9oSMvc8WbLmgeDko5pcPW2hB4QFjfl8eqoeLfqww8eZ6tbfbICPv7ePHHUzxm 0GwLIHLqZ7dR/9kuWCe3MaVzTptqwM9KsBGvxga0i8xaejHbH9ep0+oGYwdPv/TX +s5WZCBTDcpBHpPuVjkjAjIGbUTJZOqZsCQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdekkedgfeelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdlfe ehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefo ihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihii eqnecuggftrfgrthhtvghrnhepgeffjeevgfevuddvjedtvddtieejheduueelvddufedt gfefjedvkeevkeeivddvnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgr vghlsehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopedvpdhmohguvgepshhmth hpohhuthdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhspdhrtghpthht ohepphhgshhqlhdqtghomhhmihhtthgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlh drohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 31 Oct 2024 21:57:05 -0400 (EDT) Date: Fri, 1 Nov 2024 10:56:50 +0900 From: Michael Paquier To: Tom Lane Cc: pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Make all ereport() calls within gram.y provide error locations. Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="KZcY2Bips7snRWCO" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --KZcY2Bips7snRWCO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Tom, On Thu, Oct 31, 2024 at 08:09:38PM +0000, Tom Lane wrote: > Make all ereport() calls within gram.y provide error locations. >=20 > This patch responds to a comment that I (tgl) made in the > discussion leading up to 774171c4f, that really all errors > occurring during raw parsing should provide error cursors. > Syntax errors reported by Bison will have one, and most of > the handwritten ereport's in gram.y already provide one, > but there were a few stragglers. >=20 > (It is not claimed that this handles every failure reachable > during raw parsing --- out-of-memory is an obvious exception. > But this makes a good start on cases that are likely to occur.) >=20 > While we're at it, clean up the reported positions for errors > associated with LIMIT/OFFSET clauses. Previously we were > relying on applying exprLocation() to the contained expressions, > but that leads to slightly odd cursor placement, e.g. The tests of sepgsql need a refresh: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Drhinoceros&dt=3D2= 024-10-31%2020%3A52%3A13 Thanks, -- Michael --KZcY2Bips7snRWCO Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmckNWIACgkQnvQgOdby QH08Wg//YueywV3sAs9hBg5Zqu7S8I50paTTyreIzF+LMBHBjatDiKUAr8xt3t/9 4JCknKgKPIDqdEA/7FYMGKVCopJCNrKlgN21T9KmkR3oS8fYOD993VoArrj7fGxl M3QNqHDsWizCmoTM2ZxcqJ0mTyiAFa0ZFSFrQ2psormHVnFg+OAYvF+UNClkITnp R1sRcUNd8Yw4xDyCwieOwpXIl+mgX9Sx4qlX+N1dADAgRQathadTGaaOOGdaq5Vw gOvs+wZTePJJU6nfScy22RsGNgY44Y0Y3E0Ca1RZ+Dj4UrXkypenbq1wvfJoZ7m1 3j7oyjNLs3NL1Vrl+/cxLc4T1geK8wD1hvM4a9KRF3Oz4ton7bNrA8oGlIGkwhRB qiYAfVz7dbRqBJ3qp2qecKi/iVWr9qcjnL7Fd70GwWKVtpyvJh/d4qMP54t4nPU/ +CG6hr3eZSiJrS7pQOD8I88Ybu8IrRTrZbzxsNhdyA+TWmFtLpQIFtv/Tl5IJrrt 6qKofi57S/LYK9EKdh+gTAtSHjGtRe42Sz4i7XQulQbDnGQm8DZZEq+1zxQl1vfn ARw5/Y4Fvw0WpMYQROJMCdV+mRAhBfgoy4uuqaCm7DoRg6+gKAdhYg4gCzUcsoJk ftjS/htmbgwfcN6YloVubb4p7E/p5nDAOkWJGXDRI6hwBiI0kuY= =uyQv -----END PGP SIGNATURE----- --KZcY2Bips7snRWCO--