Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP
	id E78CA47600E; Wed,  3 Jul 2002 04:45:46 -0400 (EDT)
Mailbox-Line: From achill@matrix.gatewaynet.com  Wed Jul  3 04:45:46 2002
Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP
	id BA3F0475B3A; Wed,  3 Jul 2002 03:53:47 -0400 (EDT)
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g637ppG13191;
	Wed, 3 Jul 2002 10:51:51 +0300
Date: Wed, 3 Jul 2002 10:51:51 +0300 (EEST)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Jie Liang <jie@stbernard.com>
Cc: "'Jan Wieck'" <JanWieck@Yahoo.com>,
	"'Bruce Momjian'" <pgman@candle.pha.pa.us>,
	"'admin@postgresql.org'" <admin@postgresql.org>,
	"'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: Re: pg_restore cannot restore function
In-Reply-To: <7C760DAA511DC74B99E7D22189F786F101BF210A@MAIL01.stbernard.com>
Message-ID: <Pine.LNX.4.44.0207031040500.9583-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Status: No, hits=-3.5 required=5.0
	tests=IN_REP_TO,X_NOT_PRESENT,NO_MX_FOR_FROM version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/24
X-Sequence-Number: 8403

In the case that you moved your backup to another system
where possibly the shared library (.so) where the function exists is on a 
different location then thats the problem, in which case you only need
to recreate the function (with the same isstrict,iscachable attributes).

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr