Re: Warning for missing createlang

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.

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