Re: ERROR: PLPGSQL does not exist - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: ERROR: PLPGSQL does not exist
Date
Msg-id 3F5608C7.18748.5565EC5@localhost
Whole thread Raw
In response to ERROR: PLPGSQL does not exist  ("Amin Schoeib" <aschoeib@4tek.de>)
List pgsql-general
On 3 Sep 2003 at 11:44, Amin Schoeib wrote:
> When I Try to write Functions I always become the error
> That the language plpgsql doesn't exist.
> I tried it this way:
> createlang plpgsql template1
> createlang -l template1
> Procedural languages
>  Name | Trusted?
> ---------+----------
> plpgsql | t
> (1 row)
> I also restart the database but no effect.
> What am I doing wrong??
> Sorry but I'm a Postgres newbie. I worked until yet with Oracle and now we want
> to change

You need to create the language pl/pgsql so that you can create a function in
that language.

Check documentation for create lnaguage syntax or man page of createlang
command. Most probably all you need is a 'createlang plpgsql' from shell prompt
but I am probably bit rusty on details..

Bye
 Shridhar

--
Suffocating together ... would create heroic camaraderie.        -- Khan Noonian
Singh, "Space Seed", stardate 3142.8


pgsql-general by date:

Previous
From: "Amin Schoeib"
Date:
Subject: ERROR: PLPGSQL does not exist
Next
From: Csaba Nagy
Date:
Subject: Re: ERROR: PLPGSQL does not exist