X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B64AD14B2920 for ; Mon, 9 Aug 2004 13:10:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72987-08 for ; Mon, 9 Aug 2004 16:10:11 +0000 (GMT) Received: from mailengine11.web2000.activeisp.com (webmail2.activeisp.com [213.188.134.18]) by svr1.postgresql.org (Postfix) with ESMTP id DDAC214B27CB for ; Mon, 9 Aug 2004 13:03:45 -0300 (ADT) Received: from ELAPTOP (unverified [81.110.6.236]) by webmail.activeisp.com (Rockliffe SMTPRA 5.3.11) with ESMTP id for ; Mon, 9 Aug 2004 18:04:11 +0200 From: "Mike Bell" To: Subject: Re: Update from 7.3.3 to 7.3.6 Date: Mon, 9 Aug 2004 16:59:22 +0100 Organization: hashdefine ltd Message-ID: <002b01c47e29$d9a20750$6401a8c0@hashdefine.local> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal In-Reply-To: <15397.1092066881@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/48 X-Sequence-Number: 14443 Tom, Thanks for that. It appears that the tcl support is there. However, the lib now appears to be called: ./usr/lib/libpgtcl.so Is this the same? I couldn't find documentation concerning the change in file. If so then can I just edit the schema? Cheers Mike -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: 09 August 2004 16:55 To: Mike Bell Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Update from 7.3.3 to 7.3.6 "Mike Bell" writes: > We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red > Hat). However, we are having a number of problems importing the database > schema. Some of the SPs are written in TCL and it would seem that the > library has changed. > ERROR: stat failed on file '$libdir/pltcl': No such file or directory Hmm. The most obvious question is did you remember to install the postgresql-tcl RPM? "pg_config --pkglibdir" will tell you what directory $libdir expands to, and you can look in there to see if there's a pltcl.so or not. It appears from the above that the answer will be "not". regards, tom lane