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 E4DEBD1B4F4 for ; Mon, 27 Oct 2003 04:28:08 +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 72219-03 for ; Mon, 27 Oct 2003 00:27:38 -0400 (AST) Received: from necsin-fw.nec.com.sg (necsin-fw.nec.com.sg [203.127.255.1]) by svr1.postgresql.org (Postfix) with ESMTP id 06F9DD1B50A for ; Mon, 27 Oct 2003 00:27:36 -0400 (AST) Received: from kato.nec.com.sg (kato.nec.com.sg [203.127.254.2]) by necsin-fw.nec.com.sg with ESMTP id h9R4RPh0006784 for ; Mon, 27 Oct 2003 12:27:29 +0800 (SGT) Received: from necsind1.nec.com.sg ([203.127.252.220]) by kato.nec.com.sg with ESMTP id h9R4ROJT013419 for ; Mon, 27 Oct 2003 12:27:24 +0800 (SGT) Subject: Duplicate in pg_user table 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: Mon, 27 Oct 2003 12:27:29 +0800 X-MIMETrack: Serialize by Router on NECSIND1/WTC/NECSIN(Release 5.0.12 |February 13, 2003) at 10/27/2003 12:27:30 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/659 X-Sequence-Number: 4407 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 the Postgres ODBC v7.3.0100. After a few weeks of usage, when we do a \d at the sql prompt, there was a duplicate object name in the same schema, 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. We discovered that the schema in the pg_user table was duplicated also; thus causing the pg_dump to fail. Thank you, REgards.