PgAdmin uses wrong column for primary key

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: PgAdmin uses wrong column for primary key
Date: 2005-12-25 01:18:18
Message-ID: 000701c608f1$276a0d40$118b9fd9@acer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Platform: PgAdmin and server running in the same Windows XP computer.
"PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"

Language: English
Distribution: binary
Version: 1.4.0

To reproduce:

1. Run the code:

CREATE TABLE btest
( jrk numeric(3),
kontoklass char(10) primary key,
vkontoklas char(10)
) ;

CREATE TABLE test2 AS SELECT * FROM btest ;
ALTER TABLE test2 DROP jrk, ADD PRIMARY KEY (kontoklass);

2. Open table test2 for editing in pgAdmin III Edit Data window

Observed result:

column heading is: vkontoklas [PK] bpchar

PgAdmin works like vkontoklas column is primary key !

Andrus

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-12-26 12:36:10 Re: BUG: Wrong Explain diagram
Previous Message Alexander Kirpa 2005-12-24 23:15:32 BUG: Wrong Explain diagram