Unrecognized language plpgsql when CREATE FUNCTION?!

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Unrecognized language plpgsql when CREATE FUNCTION?!
Date: 2001-01-31 20:54:18
Message-ID: 3A787B7A.4409D90D@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thank you very much!

--
Why we want to teach our babies to talk and walk,
then later we tell them "sit down!", "be quiet!" ?

Democracy is not a better way for a solution,
it is just another way to spread the blames.

--Raymond

Attachment Content-Type Size
raymond.chui.vcf text/x-vcard 421 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Haberlach 2001-01-31 21:20:59
Previous Message Steve Wolfe 2001-01-31 20:51:48 Creating indeces on existing tables...