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 BC2D28B9F5F for ; Thu, 10 Feb 2005 17:33:17 +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 82221-08 for ; Thu, 10 Feb 2005 17:33:10 +0000 (GMT) Received: from mailhub1.sghms.ac.uk (mailhub1.sghms.ac.uk [194.82.51.7]) by svr1.postgresql.org (Postfix) with ESMTP id 9E2C58B9F20 for ; Thu, 10 Feb 2005 17:33:08 +0000 (GMT) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.24) id 1CzIBY-0000zy-GO for pgsql-admin@postgresql.org; Thu, 10 Feb 2005 17:33:00 +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 <0IBP00G8SI30NF@imail.sghms.ac.uk> for pgsql-admin@postgresql.org; Thu, 10 Feb 2005 17:33:00 +0000 (GMT) Date: Thu, 10 Feb 2005 17:29:27 +0000 From: Adam Witney Subject: Column duplication with \d in psql To: 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.599, required 5, autolearn=not spam, BAYES_00 -2.60) 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/81 X-Sequence-Number: 16249 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 | Thanks Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.