X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AB017D1C9FB for ; Thu, 8 Apr 2004 03:06:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81338-03 for ; Thu, 8 Apr 2004 03:06:34 -0300 (ADT) Received: from linux.ceedees.com (unknown [202.9.172.103]) by svr1.postgresql.org (Postfix) with ESMTP id 0D389D1C9B5 for ; Thu, 8 Apr 2004 03:06:32 -0300 (ADT) Received: from ceedees.com (vpsd2.ceedees.com [192.168.0.51]) by linux.ceedees.com (8.11.6/linuxconf) with ESMTP id i385vIl07030 for ; Thu, 8 Apr 2004 11:27:18 +0530 Message-ID: <4074EB64.8040604@ceedees.com> Date: Thu, 08 Apr 2004 11:34:20 +0530 From: Shanmugasundaram Doraisamy User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031114 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: problem with pg_dump - reg. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/136 X-Sequence-Number: 13109 Dear Group, Thanks for all your support to my previous postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I am facing is that when I take a dump of the DB using pg_dump and restore it using the cat pg_dump_file |psql dbname, I find that some views and functions are missing. But the same views when created manually in the newly restored database works fine. I would appreciate your input in this regard. I am using Redhat 7.3 on one machine and Redhat 8.0 on another. The same behavior is found on both. Thanks in advance, Shan.