Re: Misplaced double quotes in error message

2021-10-07 Thread Peter J. Holzer
On 2021-10-07 10:55:09 -0400, Tom Lane wrote: > Yeah. This is not as simple as it looks, because per our message > style guidelines, double quotes are used to set off inserted text, > independently of whether it is a SQL identifier or something else. > (There is a style violation in this message:

Re: Misplaced double quotes in error message

2021-10-07 Thread Tom Lane
Adrian Klaver writes: > On 10/6/21 11:17 PM, Thomas Kellerer wrote: >> consider the following table, query and error message: >> 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

Re: Misplaced double quotes in error message

2021-10-07 Thread Sunil Thakur
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* *

Re: Misplaced double quotes in error message

2021-10-07 Thread Adrian Klaver
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

Misplaced double quotes in error message

2021-10-07 Thread Thomas Kellerer
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