Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D40404773C1; Fri, 28 Jun 2002 14:57:02 -0400 (EDT) Mailbox-Line: From jie@stbernard.com Fri Jun 28 14:57:02 2002 Received: from MAIL01.stbernard.com (mail01.stbernard.com [64.154.93.162]) by postgresql.org (Postfix) with ESMTP id A78364761D2; Fri, 28 Jun 2002 14:49:39 -0400 (EDT) Received: by MAIL01.stbernard.com with Internet Mail Service (5.5.2653.19) id ; Fri, 28 Jun 2002 11:49:40 -0700 Message-ID: <7C760DAA511DC74B99E7D22189F786F101BF2104@MAIL01.stbernard.com> From: Jie Liang To: 'Bruce Momjian' , "'admin@postgresql.org'" Cc: "'pgsql-sql@postgresql.org'" Subject: pg_restore cannot restore function Date: Fri, 28 Jun 2002 11:49:39 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/401 X-Sequence-Number: 8366 I use pg_dump -Fc mydb > dbf then I create another db by: createdb mydb2 I use pg_restore -P myfunction -d mydb2 dbf cannot restore myfunction into mydb2 why?????? Jie Liang