Re: Create Language Error

On Tue, Dec 16, 2008 at 12:41 AM, jakot05 <jakot05(at)gmail(dot)com> wrote:

>
> On Mon, Dec 15, 2008 at 11:32 PM, Klint Gore <kgore4(at)une(dot)edu(dot)au> wrote:
>
>> jakot05 wrote:
>>
>>> postgres=# CREATE LANGUAGE pgpsql
>>> postgres-# ;
>>> ERROR: unsupported language «pgpsql»
>>> HINT: The supported languages are listed in the pg_pltemplate
>>>
>>> ... don't know what im doing wrong :-S
>>>
>>
>> You have to put the "pl" on the front of it.
>>
>> CREATE LANGUAGE plpgsql;
>>
>> klint.
>
>

Thanks a lot Adrian and Klint!, its works :-)

>>
>> --
>> Klint Gore
>> Database Manager
>> Sheep CRC
>> A.G.B.U.
>> University of New England
>> Armidale NSW 2350
>>
>> Ph: 02 6773 3789 Fax: 02 6773 3266
>> EMail: kgore4(at)une(dot)edu(dot)au
>>
>>
>