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.96) (envelope-from ) id 1wQy64-00218P-0w for pgsql-hackers@arkaria.postgresql.org; Sun, 24 May 2026 01:57:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQy61-00GMHE-2q for pgsql-hackers@arkaria.postgresql.org; Sun, 24 May 2026 01:57:42 +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.96) (envelope-from ) id 1wQy61-00GMH1-1w for pgsql-hackers@lists.postgresql.org; Sun, 24 May 2026 01:57:42 +0000 Received: from mail-vs1-xe33.google.com ([2607:f8b0:4864:20::e33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQy5v-000000017yn-0rYa for pgsql-hackers@postgresql.org; Sun, 24 May 2026 01:57:37 +0000 Received: by mail-vs1-xe33.google.com with SMTP id ada2fe7eead31-63124a80693so3231992137.3 for ; Sat, 23 May 2026 18:57:35 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779587852; cv=none; d=google.com; s=arc-20240605; b=KdAki9FZnDnxlydKV/DTbs1D7C3r0gXQk9RnHpiOMW8T+ZqoCscQfyqqe6qipZHWRw 6w8rqTZVMELm+mhwCq4JIbYqXBd14afED0+O0K0XwXLqvCCJN9v+p30OZI3eIZdE3ImY BpTgPPbrYMmQWmbddFkTUS9XC4cOMU4KEWCNCagUsQZOcOGRUzH9ugz5CKX5DRhYPLNG K5w4LjXTBRhGB8xQhGjPlwxv4HGyXEFmemT0c2OP/QODTbMaN84nbGUS77cogjdUEyg+ rj30hKAownJk56nv1JPc4RhPMx8I8OzAJcUC2TFnQs0oXgSqUdwNnLCLzByY+Fibw/t8 xN6Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=XRByShpjDg9ITwLI5Sl/ABzw0vmKmg4Emm+TG5wCY+8=; fh=vabo/rKRGaioPFh2W1Eva0gPOZgVh84+YbYqsgYAY7Q=; b=IftfnsSrM9VM4gEDGcMVFDa5tckEeS58+WH++HS9Qe5XXYJw6d2sT0qx4sM/sCjcYL 3uqBC6gZapULy44d8ZOAJgcGdCgNVqf4X5xQWwQtr6qtF+HLD8AyUv/hyl4kR7jQe2PS 2TxxQDr6OkDx+IKMuRJ6tSgXyHBZFGAZXUcTFMWHsWKwHCbnFovwPWzt+8qIJ/lzRIlC mih4FLfzgHWFUZ/vC/BaFvaC9X4VOOU1Nj0OjOh5N/Fev09bfBJiY0Q3Bt0gbwn8AAKY xs8KQYBncLIwTmu5HHphGPTo8Xbd6bSL9VfCFH4cDN56Y2VnKf9ihsSq8Bna2HJF+LEa tJ4w==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779587852; x=1780192652; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=XRByShpjDg9ITwLI5Sl/ABzw0vmKmg4Emm+TG5wCY+8=; b=C9UQ3Hfxn09O0UO6C49snzFEWIShDF8FjRW47gPtapFcRmpVNeRnOUC0KTi2glSBV9 1b39/6+UVcND1zW7CB2WVz9QR/jMKp4r1ujdmD8qxfbuscw/1LnTqWcgPKYJGv9njnxr qW3No+p0uY6NS7dgZwt8hNmwZzs1ddSNItdCqMBbDyzeW3I5gCgzgdZ+uByGtZZJcMPD edWxS4VsVt+rNh8xGTfRVDzWUvBV5wcsWKFsftNLn0csI1bJKu4tGCd2UdQYCZAbD+2M cPI4hAIJkclxKYPG9aQTmxhlCvM9bXE+0KgnfFg+I7uaTg6HOgMH/XW9y6g3rDIfsQ4b cLlw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779587852; x=1780192652; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=XRByShpjDg9ITwLI5Sl/ABzw0vmKmg4Emm+TG5wCY+8=; b=BZYt89Hp0DgAgGoSronTbodEeb9anoXDSnIibXehjQxkyQmO9+bHoyj3X5ZDgbpndi g2EezBbfqCz3gUiLCezlscavUgqth6f8anmWmXnP2/QFfsl1mo6QkJ6ZDWbICTP2LzIZ Lmybta1dBGtTwHUBl2JG52MD3q965+9VKYIy6NhybfTGQ2euzFvlpJxHBVWklfSgiDbw +9s2VHd9l1qPVbi2LU0l/i5l9Vl6drPcBB/xfwOuVD8oWx114H8chFbuk5qIb34TukpM f2hg65XkzQyCysAQ9cjywiN3FyzBgnFiFjRavQjspqktfvbrtVjs0yERjeao+nkUcJoK rRVg== X-Gm-Message-State: AOJu0YzYWvga0prFEV2ZnTQb9KLPIunI6YimIaUiiijH/fmiXL543L6O F2YDtGXziB4otsIK+ZMYn22RQ3nkw//kFCsO5djBjcuK8IvwsGax9rnM24WmyaToofPvRySiV22 rU8TXhCW3OanPHCKYp1Pj7lIsoQ65BI4= X-Gm-Gg: Acq92OHShxsBfVFTGoJNR+cOwGTz5eKaYI+aX9Nl+n53he8YKkHhyLONbDERuhcSOD6 0mdXKAL1Rmi50vp7LHBkiw696rJur4VvWKg/rXCR2KAgYpMIUyPRajc9qBxnihZZKtBkFBH/+FW d5SoFzhv6i9w+8sqhupbxyOgrrr1KvdD7vjjwTDuV1tP3aT7z1ezECif92luqiiqnh6zMvuSEuf 4deobjYyX8Ii9Jk0M+dsCzXwLRmPKfbXI8zs0PfDPTKQpokBekgHZbuwMJw7oR3gD4vs9+tMY0u UqSzDY0Krcjd4zqgVPGq4ygE6pHlRMArjJUgqQN6js1+psCR94P4OvXcY+dXBUgucbg1od+lOZX BZlsTmRBEarlreJsmhHLjpiJsMkihTiHLUVzQ7qUoqdFB9A5poCRbpC+Au1eWerI5qH6+yceXFE qnM6GgxC26NE6+n/t0eiNQzA== X-Received: by 2002:a05:6102:3f08:b0:650:aa33:5f2c with SMTP id ada2fe7eead31-67c738b4aefmr4600923137.7.1779587851834; Sat, 23 May 2026 18:57:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: jian he Date: Sun, 24 May 2026 09:56:55 +0800 X-Gm-Features: AVHnY4J4Cl5VTeMOueeRItQQeUGORkUSGnMCiF19iyJcJaHOkEznZ0vCBs401xw Message-ID: Subject: Re: [PATCH] psql: Display SQLSTATE macro name in verbose error reports To: Aaryan Parik Cc: pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, May 24, 2026 at 3:18=E2=80=AFAM Aaryan Parik wrote: > > Example output: > ERROR: 42601: syntax error at or near "FRO" > LINE 1: SELECT * FRO; > ^ > LOCATION: scanner_yyerror, scan.l:1220 > SQLSTATE name: ERRCODE_SYNTAX_ERROR > > I believe this will be a handy quality-of-life improvement for developers= . Looking forward to any feedback > This seems identical to the patch submitted in the previous email thread, [= 0]. [0]: https://www.postgresql.org/message-id/CAK3UJRGc2RKfQMjwVDAwsuOJuobq3d4= %2BQf9KWK1NHmK1vaqyxQ%40mail.gmail.com