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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
