X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 347678B9FE7 for ; Thu, 10 Feb 2005 17:53:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84246-04 for ; Thu, 10 Feb 2005 17:52:43 +0000 (GMT) Received: from mailhub1.sghms.ac.uk (mailhub1.sghms.ac.uk [194.82.51.7]) by svr1.postgresql.org (Postfix) with ESMTP id 334B98B9F20 for ; Thu, 10 Feb 2005 17:52:42 +0000 (GMT) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.24) id 1CzIUR-00019N-Fs; Thu, 10 Feb 2005 17:52:31 +0000 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.2 Patch 2 (built Jul 14 2004)) with ESMTPA id <0IBP00GJ6IZINF@imail.sghms.ac.uk>; Thu, 10 Feb 2005 17:52:31 +0000 (GMT) Date: Thu, 10 Feb 2005 17:48:57 +0000 From: Adam Witney Subject: Re: Column duplication with \d in psql In-reply-to: <200502101745.j1AHj6h11515@candle.pha.pa.us> To: Bruce Momjian Cc: pgsql-admin Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT User-Agent: Microsoft-Entourage/10.1.1.2418 X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH1: No virueses detected X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-2.099, required 5, BAYES_00 -2.60, MY_NO_QU 0.50) X-MailScanner-From: awitney@sghms.ac.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/83 X-Sequence-Number: 16251 On 10/2/05 5:45 pm, "Bruce Momjian" wrote: > Adam Witney wrote: >> >> Something strange has just appeared in my database, can anyone explain this >> duplication of columns: >> >> test=# \d plate_reporter >> Table "plate_reporter" >> Column | Type | Modifiers >> -------------------+---------+-------------------------------------------- >> plate_reporter_id | integer | not null, >> plate_reporter_id | integer | not null, >> plate_id | integer | not null >> plate_id | integer | not null >> well_address | text | not null >> well_address | text | not null >> reporter_id | integer | not null >> reporter_id | integer | not null >> dilution_factor | text | >> dilution_factor | text | > > What version of PostgreSQL are you using? select version(); version ---------------------------------------------------------------------------- --------------------------------------------- PostgreSQL 7.4.6 on powerpc-apple-darwin7.6.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495) (1 row) > Old versions could get > duplicates in some system tables. Do you have a two row for > 'plate_reporter' in pg_class? Ah yes, there are two rows for 'plate_reporter' in pg_class. What would be the best way of fixing this? Thanks Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.