Re: [PATCHES] Warning for missing createlang

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