Andrus Moor wrote:
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 !
Good catch!
The PK detection code in the view tool assumed the column numbering
would start with one, without holes. This doesn't always true, esp. in
your case.
Fixed for HEAD and 1.4.2, thanks for reporting.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
