Re: pgAdmin3 shows duplicate columns in a table

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Michael <chainsawchihuahua(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAdmin3 shows duplicate columns in a table
Date: 2011-10-18 05:30:34
Message-ID: CA+OCxoxLpnbrrM6NUiP5JAyz8V8gyQOX4StRWQFV5m46SaV7VA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Tue, Oct 18, 2011 at 1:41 AM, Michael <chainsawchihuahua(at)gmail(dot)com> wrote:
> Hi, everyone.
>
> I think I've discovered a bug with pgAdmin3: pgAdmin3 is showing four
> duplicate 'id' columns for one of my tables. The column named 'id'
> happens to be a primary key for the table. I have tried deleting and
> recreating both the individual table and the entire database, but
> neither solves the problem.
>
> Moreover, this doesn't seem to be a problem with postgres, because psql
> shows just the single 'id' column when I bring up details on the table.
> I asked first in IRC a few times and finally was encouraged to post to
> this mailing list.
>
> If you need more information regarding this bug, please let me know.

Can you post the DDL you used to create the table that shows up this way please?

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Francisco Leovey 2011-10-18 21:26:05 Re: Windows 7 - PgAdmin II no longer connects to databases
Previous Message Michael 2011-10-18 00:41:47 pgAdmin3 shows duplicate columns in a table