Re: Unrecognized language plpgsql when CREATE FUNCTION?! - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Unrecognized language plpgsql when CREATE FUNCTION?!
Date
Msg-id Pine.BSF.4.21.0102051529010.39272-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Unrecognized language plpgsql when CREATE FUNCTION?!  (Raymond Chui <raymond.chui@noaa.gov>)
List pgsql-general
You probably need to run createlang (createlang plpgsql databasename)

On Wed, 31 Jan 2001, Raymond Chui wrote:

> I have install all latest PostgreSQL 7.0.3 packages except python
> into my Redhat Linux 6.2
>
> When I CREATE FUNCTION fname() RETURN OPAQUE AS '
> DECLARE
>     ...;
> BEGIN
>     ....;
> END;
> ' LANGUAGE 'plpgsql';
>
> I got Unrecognized language plpgsql, it only recognized sql, C, internal
> and
> created_procedure_name.
> Well, in Postgres documents has examples for Language plpgsql.
> Please tell me what do I missing, what other packages I need to install?


pgsql-general by date:

Previous
From: Mike Hoskins
Date:
Subject: Re: MySQL file system
Next
From: "Oliver Elphick"
Date:
Subject: Revised Debian packages for PostgreSQL 7.1beta4