From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: nozdrum@gmx.de
Subject: BUG #16726: Invalid input syntax is not a useful error message
Date: Wed, 18 Nov 2020 23:55:44 +0000
Message-ID: <16726-96431209e6e5f536@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16726
Logged by: No useful error message
Email address: nozdrum@gmx.de
PostgreSQL version: 13.0
Operating system: Linux
Description:
I tried to update the uuid-value of a user with a uuid-literal. Since the
documentation on this is so useless:
https://www.postgresql.org/docs/13/datatype-uuid.html I had to try and
finally give up.
Example-query i tried:
update users set
some_uuid_field = 'dec3d6c4-c32e-45c6-1eae3df44fbf'
where
id = 5
I tried ( as is suggested in your documentation) to set with and without
sorounding single quotation mark and with and without braces. I always got
the same useless error message
`ERROR: invalid input syntax for type uuid:
"dec3d6c4-c32e-45c6-1eae3df44fbf"`
I also tried curly braces ( as suggested by your awful documentation ), but
this just leads to
`syntax error at or near "{"`
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.
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, nozdrum@gmx.de
Subject: Re: BUG #16726: Invalid input syntax is not a useful error message
In-Reply-To: <16726-96431209e6e5f536@postgresql.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