pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Vik Fearing <vik@postgresfriends.org>
To: nozdrum@gmx.de
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16726: Invalid input syntax is not a useful error message
Date: Thu, 19 Nov 2020 01:15:09 +0100
Message-ID: <1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org> (raw)
In-Reply-To: <16726-96431209e6e5f536@postgresql.org>
References: <16726-96431209e6e5f536@postgresql.org>

On 11/19/20 12:55 AM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Example-query i tried:
> update users set
>   some_uuid_field = 'dec3d6c4-c32e-45c6-1eae3df44fbf'
> where
>   id = 5
> 
> What I want:
> a) That your documentation tells me the syntax for this
> b) That your error messages FOR ONCE are not useless and tell me the
> expected syntax, you are wasting millions of hours of developer time and
> human life, because you can not be asked to make useful error messages.

The documentation tells you exactly what the syntax should be, and the
error message couldn't be clearer.  It says "specifically a group of 8
digits followed by three groups of 4 digits followed by a group of 12
digits" but you've only supplied two groups of 4 digits in the middle.

-- 
Vik Fearing





view thread (7+ messages)  latest in thread

Message-ID: <1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org>
Permalink:  ../1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org/
Also on:    postgresql.org/message-id/1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: vik@postgresfriends.org, nozdrum@gmx.de, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16726: Invalid input syntax is not a useful error message
  In-Reply-To: <1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox