X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23AA2D1B520 for ; Wed, 22 Oct 2003 10:26:28 +0000 (GMT) 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 71248-10 for ; Wed, 22 Oct 2003 07:25:59 -0300 (ADT) Received: from necsin-fw.nec.com.sg (necsin-fw.nec.com.sg [203.127.255.1]) by svr1.postgresql.org (Postfix) with ESMTP id 991A7D1B52C for ; Wed, 22 Oct 2003 07:25:55 -0300 (ADT) Received: from kato.nec.com.sg (kato.nec.com.sg [203.127.254.2]) by necsin-fw.nec.com.sg with ESMTP id h9MAPoh0014730 for ; Wed, 22 Oct 2003 18:25:51 +0800 (SGT) Received: from necsind1.nec.com.sg ([203.127.252.220]) by kato.nec.com.sg with ESMTP id h9MAPnJT011728 for ; Wed, 22 Oct 2003 18:25:49 +0800 (SGT) Subject: Postgresql performance To: pgsql-performance@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: CHEWTC@ap.nec.com.sg Date: Wed, 22 Oct 2003 18:25:51 +0800 X-MIMETrack: Serialize by Router on NECSIND1/WTC/NECSIN(Release 5.0.12 |February 13, 2003) at 10/22/2003 06:25:52 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200310/569 X-Sequence-Number: 4317 Hi Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have Windows2000 client machines inserting records into the Postgresql tables via ODBC. After a few weeks of usage, when we do a \d at the sql prompt, there was a duplicate object name, ie it can be a duplicate row of index or table. When we do a \d table_name, it will show a duplication of column names inside the table. It doesnt affect the insertion/updating of the tables, but when we do a pg_dump -Da -t > /exp/.sql, it will not do a proper backup/dump. Do we need to apply any patches or maintenace? Please be informed that NEC Singapore Pte Ltd is now known as NEC Solutions Asia Pacific Pte Ltd. Our address and contact numbers remain. Email: chewtc@ap.nec.com.sg http://www.nec.com.sg/ap Thank you, REgards.