Re: Doing better at HINTing an appropriate column within errorMissingColumn()

From: Christoph Berg <cb(at)df7cb(dot)de>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: Peter Geoghegan *EXTERN* <pg(at)heroku(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Date: 2014-03-28 09:54:58
Message-ID: 20140328095457.GA15310@msgid.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: Albe Laurenz 2014-03-28 <A737B7A37273E048B164557ADEF4A58B17CE8DEA(at)ntex2010i(dot)host(dot)magwien(dot)gv(dot)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(at)df7cb(dot)de | http://www.df7cb.de/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2014-03-28 12:57:03 Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Previous Message Albe Laurenz 2014-03-28 08:47:34 Re: Doing better at HINTing an appropriate column within errorMissingColumn()