ERROR: Unrecognized language specified ... - Mailing list pgsql-general

From Kevin HaleBoyes
Subject ERROR: Unrecognized language specified ...
Date
Msg-id 3BC355AB.7090401@yahoo.com
Whole thread Raw
Responses Re: ERROR: Unrecognized language specified ...  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: ERROR: Unrecognized language specified ...  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
I'm creating a function (for use in a trigger) from the example in the
documentation and encountered an error.  If I type the following at
the psql prompt (database and user are opf):

opf=> create function opf_user_fillin() returns opaque as '
opf'> begin
opf'> new.opf_user_id := nextval(opf_user_sequence);
opf'> return new;
opf'> end;
opf'> '
opf-> language 'plpgsql'
opf-> ;

I get the following error:

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

Can I enable the plpgsql language on my system?  If so, how?  If not,
what are my options (ie, what do I have to do to get plpgsql support)?

I'm pretty new to PostgreSQL but no stranger to compiling systems from source
(or writing the source for that matter).  I'm running a RedHat Linux 7.1 system
with the PostgreSQL that comes with the OS.

Thanks,
Kevin.


pgsql-general by date:

Previous
From: xr256205@europe.com (reywob)
Date:
Subject: Contents of greatbridge.com?
Next
From: "Steve Brett"
Date:
Subject: Re: triggers