Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA03775 for ; Mon, 10 May 1999 16:45:52 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id KVHY9KJ3; Mon, 10 May 1999 15:45:34 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Mon, 10 May 1999 15:48:35 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1454D5@lambic.prevuenet.com> From: Michael J Davis To: "'Adam H. Pendleton'" , pgsql-sql@hub.org Subject: RE: [SQL] plpgsql error Date: Mon, 10 May 1999 15:46:59 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Look in the docs for create language. You need to execute a create language command to tell postgres to recognize plpgsql. I believe the library is created as part of the install process. > -----Original Message----- > From: Adam H. Pendleton [SMTP:apendleton@vgsinc.com] > Sent: Monday, May 10, 1999 2:32 PM > To: pgsql-sql@hub.org > Subject: [SQL] plpgsql error > > I get this error when I try to create a function using plpgsql: > > ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. > Recognized languages are sql, C, internal and the created procedural > languages. > > Do I need to specify another flag when I compile Postgresql? > > Adam > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Si hoc legere scis nimium eruditionis habes. > >