Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id DAA78031 for ; Tue, 11 May 1999 03:37:12 -0400 (EDT) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@hub.org id m10h74Z-000EBXC; Tue, 11 May 99 09:35 MET DST Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] plpgsql error To: alewis@themecca.net (Andy Lewis) Date: Tue, 11 May 1999 09:35:27 +0200 (MET DST) Cc: apendleton@vgsinc.com, pgsql-sql@hub.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Andy Lewis" at May 10, 99 04:05:22 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > 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) #