Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA23594 for ; Tue, 11 May 1999 10:22:29 -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 KVHY9SG8; Tue, 11 May 1999 09:22:12 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Tue, 11 May 1999 09:25:13 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC1454DD@lambic.prevuenet.com> From: Michael J Davis To: "'jwieck@debis.com'" , alewis@themecca.net Cc: apendleton@vgsinc.com, pgsql-sql@hub.org Subject: RE: [SQL] plpgsql error Date: Tue, 11 May 1999 09:23:32 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" Gets my vote. Should we also consider doing this for Perl too? I turn them all on in my installation. I don't use either Perl or TCL yet but want to make sure they are available if 1) I ever want to or 2) a need arises that is would be better suited to either Perl or TCL. Thanks, Michael D. -----Original Message----- From: jwieck@debis.com [SMTP:jwieck@debis.com] Sent: Tuesday, May 11, 1999 1:35 AM To: alewis@themecca.net Cc: apendleton@vgsinc.com; pgsql-sql@hub.org Subject: Re: [SQL] plpgsql error > > Edit: /usr/src/pgsql/postgresql-6.4.2/src/pl/plpgsql/src/mklang.sql > > Change: as '${exec_prefix}/lib/plpgsql.so' > to: as '/usr/local/pgsql/lib/plpgsql.so' > > Then: psql your_db < mklang.sql > > This should really be part of the documentation as I wasted two days on > this same problem a few weeks back. And this became IMHO an FAQ. Should we avoid it by installing PL/pgSQL and PL/Tcl (if built) by default in the template1 database during intidb? Installing it in template1 would have the effect that it will be available after every createdb. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #