BUG #16726: Invalid input syntax is not a useful error message

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: nozdrum(at)gmx(dot)de
Subject: BUG #16726: Invalid input syntax is not a useful error message
Date: 2020-11-18 23:55:44
Message-ID: 16726-96431209e6e5f536@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16726
Logged by: No useful error message
Email address: nozdrum(at)gmx(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-11-19 00:02:34 Re: BUG #16722: PG hanging on COPY when table has close to 2^32 toasts in the table.
Previous Message Andy S 2020-11-18 23:49:20 Re: BUG #16714: INSERT ON CONFLICT DO UPDATE fails to infer constraint if it's not at top-level partition