Andrew Dunstan <[EMAIL PROTECTED]> writes: > Bruce Momjian wrote: >>> HINT: Perhaps you need to use 'createlang' to load the language into >>> the database, or you mistyped the language name.
> Why not list out the languages we *do* know about, and tell them it's > not in the list? Or is that too much work? Seems like it would clutter the error message without really addressing Bruce's concern. I doubt that seeing the list of available languages would do much to jog a newbie's memory about needing to run createlang. We could answer my objection about the hint popping out on misspelled language names if the code were to arrange to put out the hint only when the language name is one of "plpgsql", "pltcl", "pltclu", etc. This would have to use a hard-coded list of loadable language names, since by definition looking in pg_language won't help. It would be enough of a maintenance PITA that I don't especially want to do it ... but it would ensure that the hint is likely to be relevant. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings