Re: [HACKERS] Column mis-spelling hints vs case folding

2015-04-07 Thread Greg Stark
On 7 Apr 2015 09:37, "Robert Haas" wrote: > > On Sun, Apr 5, 2015 at 12:16 PM, Tom Lane wrote: > > A newbie error that we see *constantly* is misunderstanding identifier > > case-folding rules. > > I think this hint might be a lot more useful if its comparison mechanism > > were case-insensitive

Re: [HACKERS] Column mis-spelling hints vs case folding

2015-04-07 Thread Robert Haas
On Sun, Apr 5, 2015 at 12:16 PM, Tom Lane wrote: > 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); > CRE

[HACKERS] Column mis-spelling hints vs case folding

2015-04-05 Thread Tom Lane
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 "ba