ERROR: Unrecognized language specified ...
От | Kevin HaleBoyes |
---|---|
Тема | ERROR: Unrecognized language specified ... |
Дата | |
Msg-id | 3BC355AB.7090401@yahoo.com обсуждение исходный текст |
Ответы |
Re: ERROR: Unrecognized language specified ...
Re: ERROR: Unrecognized language specified ... |
Список | 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 по дате отправления: