Postgres Pro
Downloads
Home   >   mailing lists

Re: Doing better at HINTing an appropriate column within errorMissingColumn() - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Date
Msg-id 20140328095457.GA15310@msgid.df7cb.de
Whole thread Raw
In response to Re: Doing better at HINTing an appropriate column within errorMissingColumn()  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-hackers
Tree view 
Re: Albe Laurenz 2014-03-28 <A737B7A37273E048B164557ADEF4A58B17CE8DEA@ntex2010i.host.magwien.gv.at>
> > ERROR:  42703: column ol.orderids does not exist
> > LINE 1: ...* from orders o join orderlines ol on o.orderid = ol.orderid...
> >                                                              ^
> > HINT:  Perhaps you meant to reference the column "ol"."orderid".
>
> This sounds like a mild version of DWIM:
> http://www.jargondb.org/glossary/dwim
>
> Maybe it is just me, but I get uncomfortable when a program tries
> to second-guess what I really want.

I find it very annoying when zsh asks me "did you mean foo [y/n]" and
I need to confirm that, but I'd find a mere HINT that I can easily
ignore a very useful feature. +1 for the idea.

Christoph
--
cb@df7cb.de | http://www.df7cb.de/

pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Next
From: Michael Paquier
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()