On Thu, 14 Feb 2002, Pam Wampler wrote: > I am new to postgresql -- I am trying to create a trigger on a table -- > I get this error on the function > ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. > Recognized languages are sql, C, internal, and created procedural > languages.
You'll need to use createlang to add the plpgsql language to the database (it's not added by default). I believe it's createlang plpgsql <database> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org