[pgadmin-support] PgAdmin uses wrong column for primary key

[Andrus Moor]

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 


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend