Re: Misplaced double quotes in error message

It means
Error thrown by Postgres: Hint: Perhaps you meant to reference the column
"t.someColumn".
must be Hint: Perhaps you meant to reference the column t."someColumn".

*Thanks and Regards,Sunil M. K. Thakur*
<https://www.linkedin.com/in/smthakur19> *
<https://twitter.com/smthakur19> <https://www.facebook.com/smthakur19>*

On Thu, 7 Oct 2021 at 19:09, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 10/6/21 11:17 PM, Thomas Kellerer wrote:
> > Hello,
> >
> > consider the following table, query and error message:
> >
> > create table t
> > (
> > "someColumn" int
> > );
> >
> > select t.someColumn
> > from t;
> >
> >
> > ERROR: column t.somecolumn does not exist
> > Hint: Perhaps you meant to reference the column "t.someColumn".
> >
> >
> > For someone proficient in SQL it's pretty clear what the error message
> means,
> > but the quotes can be misleading for someone who doesn't really
> understand
> > what's going on.
>
> FYI, errors are generically double quoted:
>
> ERROR: invalid input syntax for type integer: "one"
>
> This is not specific to identifier quoting.
>
> >
> > I think if the error message quoted the column name the way it should
> actually
> > be used, it would make things easier for someone not used to this, e.g.:
> >
> > Hint: Perhaps you meant to reference the column t."someColumn".
> >
> > Because when the user takes the error message literally they might be
> tempted
> > to use "t.someColumn" just to be confronted with the same error message
> again
> > which then seems even more confusing.
> >
> >
> >
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>