You'll need to use createlang to add the handler. IIRC, it's createlang <lang> <database>
On Tue, 9 Oct 2001, Kevin HaleBoyes wrote: > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
