Re: unrecognized language plpgsql - Mailing list pgsql-general

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: unrecognized language plpgsql
Date
Msg-id slrn9cm16k.bme.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to unrecognized language plpgsql  (DaVinci <bombadil@wanadoo.es>)
Responses problems with variabiles in plpgsql
Re: Re: unrecognized language plpgsql
List pgsql-general
DaVinci <bombadil@wanadoo.es> wrote:
>     ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.

> I use Debian packages for Pg 7.1 BETA4. I thought plpgsql was integrated by
> default, but see it is not so.

I have the same problem with 7.1RC2 built using Oliver's Debian diff for
7.1beta4.

> Might I install plpgsql as procedural language

Yes. Make sure you've installed the postgresql-pl.deb and run createlang(1)
for your databases.

HTH,
Ray
--
Hacker and proud.

pgsql-general by date:

Previous
From: Gabriel Lopez
Date:
Subject: Application install postgresql
Next
From: Diana Cionoiu
Date:
Subject: problems with variabiles in plpgsql