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.
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 |