Column mis-spelling hints vs case folding

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Column mis-spelling hints vs case folding
Дата
Msg-id 24297.1428250599@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Column mis-spelling hints vs case folding  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
A newbie error that we see *constantly* is misunderstanding identifier
case-folding rules.  ISTM that commit e529cd4ff missed a chance to help
with that.  You do get a hint for this:

regression=# create table t1 (foo int, "Bar" int);
CREATE TABLE
regression=# select bar from t1;
ERROR:  column "bar" does not exist
LINE 1: select bar from t1;              ^
HINT:  Perhaps you meant to reference the column "t1"."Bar".

but apparently it's just treating that as a vanilla one-mistyped-character
error, because there's no hint for this:

regression=# create table t2 (foo int, "BAR" int);
CREATE TABLE
regression=# select BAR from t2;
ERROR:  column "bar" does not exist
LINE 1: select BAR from t2;              ^

I think this hint might be a lot more useful if its comparison mechanism
were case-insensitive.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: PATCH: Reducing lock strength of trigger and foreign key DDL
Следующее
От: Artem Luzyanin
Дата:
Сообщение: PATCH: Spinlock Documentation