Did you execute the following after you created your database? CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; These are needed for the plpgsql language to work. -----Original Message----- From: chard [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 10:40 PM To: [EMAIL PROTECTED] Subject: plpgsql language hello, i got this error when i tried to create a function "unrecognized language specified in CREATE FUNCTION: 'plpgsql'" why is that?