Received: from m1p17-235.waterauthority.state.fl.us (m1p17-235.waterauthority.state.fl.us [209.4.17.235]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA56707 for ; Tue, 11 May 1999 13:26:43 -0400 (EDT) (envelope-from nisai@m1p17-235.waterauthority.state.fl.us) Received: from lagrange (lagrange [209.4.17.235]) by m1p17-235.waterauthority.state.fl.us (8.9.1b+Sun/8.9.1) with SMTP id NAA27127; Tue, 11 May 1999 13:25:50 -0400 (EDT) Message-Id: <199905111725.NAA27127@m1p17-235.waterauthority.state.fl.us> Date: Tue, 11 May 1999 13:25:50 -0400 (EDT) From: "Dr. Nisai Wanakule" Reply-To: "Dr. Nisai Wanakule" Subject: RE: [SQL] plpgsql error To: pgsql-sql@hub.org Cc: michael.j.davis@tvguide.com MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: vnqeREL+984F2bHqyvZYMA== X-Mailer: dtmail 1.3.0 CDE Version 1.3 SunOS 5.7 sun4u sparc What version that has Procedural Language support for Perl? >X-Authentication-Warning: hub.org: majordom set sender to owner-pgsql-sql@postgreSQL.org using -f >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 > >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) # > > > -- Nisai Wanakule, PH.D., P.E. Tampa Bay Water 2535 Landmark Dr., Suite 211 Clearwater, FL 33761 Tel 727/791-2373 Fax 727/791-2388 SunCom: 513-7010