Bruce Momjian wrote:
Bruce Momjian wrote:
I have written a patch to issue an hint if someone tries to create a function in a language that isn't loaded into the database:
test=> CREATE FUNCTION xx() RETURNS INT AS ' test'> select 1' test-> LANGUAGE 'plpgsql'; ERROR: language "plpgsql" does not exist HINT: Perhaps you need to use 'createlang' to load the language into the database.
I know Peter didn't like this idea in the past, but we are getting too
many people who forget createlang, and with our new HINT tags, it seems
appropriate.
OK, Peter and Tom don't like it. :-(
How about this, that also suggests you mistyped the name:
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?
andrew
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
