Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16726: Invalid input syntax is not a useful error message - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16726: Invalid input syntax is not a useful error message
Date
Msg-id CAKFQuwaAMEoAZK8fj2F1WDFjB=VL6qt50_0dnKR8rx6NvtG2RQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16726: Invalid input syntax is not a useful error message  (Christophe Pettus <xof@thebuild.com>)
List pgsql-bugs
Tree view
On Wed, Nov 18, 2020 at 5:20 PM Christophe Pettus <xof@thebuild.com> wrote:
> 123e4567-e89b-12d3-a456-426614174000
> xxxxxxxx-xxxx-Mxxx-Nxxx-xxxxxxxxxxxx

The error message is exactly correct: You did not give the correct format for the character representation of the UUID.


I wouldn't oppose a "Hint: expected length is 32 hex characters but the input only has 28."

UUIDs aren't exactly friendly to the eyes, even hyphenated.

David J.

pgsql-bugs by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: BUG #16726: Invalid input syntax is not a useful error message
Next
From: Andres Freund
Date:
Subject: Re: BUG #16726: Invalid input syntax is not a useful error message