ERROR: Unrecognized language specified ...

From: Kevin HaleBoyes <kcboyes(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: Unrecognized language specified ...
Date: 2001-10-09 19:53:15
Message-ID: 3BC355AB.7090401@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keary Suska 2001-10-09 20:14:04 Re: Problems installing with --with-python
Previous Message Eric D Nielsen 2001-10-09 19:20:46 Problems installing with --with-python