Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA10897 for ; Mon, 10 May 1999 17:35:37 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id RAA09248; Mon, 10 May 1999 17:34:55 -0400 (EDT) To: Michael J Davis cc: "'Adam H. Pendleton'" , pgsql-sql@hub.org Subject: Re: [SQL] plpgsql error In-reply-to: Your message of Mon, 10 May 1999 15:46:59 -0500 <93C04F1F5173D211A27900105AA8FCFC1454D5@lambic.prevuenet.com> Date: Mon, 10 May 1999 17:34:55 -0400 Message-ID: <9246.926372095@sss.pgh.pa.us> From: Tom Lane Michael J Davis writes: > 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. plpgsql isn't installed into the system by default; you have to do the appropriate incantation after installing and starting the base Postgres system. ISTR there is a shell script you should run to do all that's needful --- look in the plpgsql docs and/or source files. regards, tom lane