Thread: Problem with 'plpgsql'

Problem with 'plpgsql'

From
Thirumoorthy Bhuvneswari
Date:
hi,
I am using Postgresql-7.0.3 with RedHat Linux-7.1. I
tried to create a simple plpgsql function as given in
the documentation which gives me a note as the
following:

'ERROR: Unrecognized language specified in a CREATE
FUNCTION: 'plpgsql'. Recognized languages are sql,C,
internal and the created procedural languages'.

I don't know how to install 'plpgsql' separately.
Please help me. thanks in advance.

bhuvana.

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: Problem with 'plpgsql'

From
Thomas Beutin
Date:
Hi,

have a look into
http://www.postgresql.org/idocs/index.php?sql-createlanguage.html
May this helps You.

greetz.
-tb

On Tue, Jun 18, 2002 at 10:25:29PM -0700, Thirumoorthy Bhuvneswari wrote:
> hi,
> I am using Postgresql-7.0.3 with RedHat Linux-7.1. I
> tried to create a simple plpgsql function as given in
> the documentation which gives me a note as the
> following:
>
> 'ERROR: Unrecognized language specified in a CREATE
> FUNCTION: 'plpgsql'. Recognized languages are sql,C,
> internal and the created procedural languages'.
>
> I don't know how to install 'plpgsql' separately.
> Please help me. thanks in advance.
>
> bhuvana.
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.