Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0O5uQ047793 for ; Wed, 24 Jan 2001 00:56:26 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 77956 invoked by uid 89); 24 Jan 2001 05:56:17 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 24 Jan 2001 05:56:17 -0000 Received: by localhost with Microsoft MAPI; Tue, 23 Jan 2001 22:56:15 -0700 Message-ID: <01C0858F.B0B1E540.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'chard'" , "pgsql-sql@postgresql.org" Subject: RE: plpgsql language Date: Tue, 23 Jan 2001 22:56:10 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/312 X-Sequence-Number: 984 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:chard@hindang.msuiit.edu.ph] Sent: Tuesday, January 23, 2001 10:40 PM To: pgsql-sql@postgresql.org 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?