Re: hint infrastructure setup (v3)

Stephan Szabo wrote:
> > I hate to say it but I don't see these hints as being very helpful.
>
> I can see them as potentially being useful for people who don't have alot
> of knowledge of SQL or our dialect thereof.  I think some of the ones
> shown may need better wording (for example the ones above basically seem
> to mean go look at the help for create user which is pretty much the same
> as the error on its own, but perhaps with a longer hint, it might be less
> so) but I think it illustrates the point for these kinds of queries.  I'm
> not sure that the HINT strings would be as meaningful in the middle of
> complicated select/update/etc queries, but that would be something to see.
>
> I'm not sure it's PostgreSQL's responsibility to teach SQL or even really
> to teach our own commands, but if it were possible to do without much of a
> performance, readability or maintenance cost, it'd probably be worth
> doing.  I can't really say much specifically about the patch either way on
> any of those grounds (having not actually looked).

I wonder if we could just do a \h command as a hint.  In some cases, it
might be clearer than printing some text.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073