Re: BUG #13832: Syntax errors are extremely unfriendly

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13832: Syntax errors are extremely unfriendly
Date: 2015-12-28 20:28:42
Message-ID: n5s61o$um9$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

tdhutt(at)gmail(dot)com schrieb am 24.12.2015 um 11:44:
> The following bug has been logged on the website:
>
> Bug reference: 13832
> Logged by: Tim
> Email address: tdhutt(at)gmail(dot)com
> PostgreSQL version: 9.3.5
> Operating system: Linux
> Description:
>
> When you have a syntax error in PostgreSQL (or MySQL for that matter) you
> get a message like this:
>
>> ERROR: syntax error at or near "FROM"
>> Position: 8
>
> This is not very user-friendly to put it mildly! Compare this with Clang's
> error messages (http://clang.llvm.org/diagnostics.html) which give you the
> exact location of the error, and also what was expected, and even
> suggestions to fix it!

Actually I think Postgres has one of the best implementations of error messages.

Which one of the following:

http://www.sql-workbench.net/comparison/why_error_messages_matter.html

do you find more user friendly?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2015-12-28 20:38:50 Re: BUG #13832: Syntax errors are extremely unfriendly
Previous Message John McKown 2015-12-28 20:15:52 Re: BUG #13832: Syntax errors are extremely unfriendly