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 3F38C14B27FC for ; Mon, 9 Aug 2004 12:18:57 -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 54246-06 for ; Mon, 9 Aug 2004 15:18:54 +0000 (GMT) Received: from mailengine2.web2000.activeisp.com (webmail2.activeisp.com [213.188.134.18]) by svr1.postgresql.org (Postfix) with ESMTP id 6E10414B27FF for ; Mon, 9 Aug 2004 12:18:49 -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 17:18:47 +0200 From: "Mike Bell" To: Subject: Update from 7.3.3 to 7.3.6 Date: Mon, 9 Aug 2004 16:14:43 +0100 Organization: hashdefine ltd Message-ID: <002601c47e23$9cefc190$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 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/43 X-Sequence-Number: 14438 Hi, 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. In the dump of the schema we have (comments removed for brevity): CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler; CREATE FUNCTION pltcl_call_handler () RETURNS language_handler AS '$libdir/pltcl', 'pltcl_call_handler' LANGUAGE c; CREATE TRUSTED PROCEDURAL LANGUAGE pltcl HANDLER pltcl_call_handler; However, when importing we get: ERROR: stat failed on file '$libdir/pltcl': No such file or directory What is the best way of sorting this out? Cheers & TIA Mike