| Lists: | pgadmin-support |
|---|
| From: | Michael <chainsawchihuahua(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | pgAdmin3 shows duplicate columns in a table |
| Date: | 2011-10-18 00:41:47 |
| Message-ID: | 1318898507.1930.8.camel@michael-Satellite-A505D |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
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.
Ubuntu GNU/Linux 11.04
pgAdmin3 v1.12.2
PostgreSQL 8.4
psql 8.4.9
--
Mike N.
| 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 |
| 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