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 1kfXbb-0000Mj-2D for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Nov 2020 00:15:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfXbZ-00023r-QN for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Nov 2020 00:15:17 +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 1kfXbZ-00023j-KR for pgsql-bugs@lists.postgresql.org; Thu, 19 Nov 2020 00:15:17 +0000 Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfXbW-0006FZ-Hv for pgsql-bugs@lists.postgresql.org; Thu, 19 Nov 2020 00:15:16 +0000 X-Originating-IP: 79.88.149.14 Received: from [172.16.255.146] (14.149.88.79.rev.sfr.net [79.88.149.14]) (Authenticated sender: vik@postgresfriends.org) by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id 2CE2F1C0003; Thu, 19 Nov 2020 00:15:09 +0000 (UTC) Subject: Re: BUG #16726: Invalid input syntax is not a useful error message To: nozdrum@gmx.de, pgsql-bugs@lists.postgresql.org References: <16726-96431209e6e5f536@postgresql.org> From: Vik Fearing Message-ID: <1113de7f-65e1-2c2b-2bbf-31b4a5733f2c@postgresfriends.org> Date: Thu, 19 Nov 2020 01:15:09 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <16726-96431209e6e5f536@postgresql.org> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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