[BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

[Boonchai]

The following bug has been logged online:

Bug reference:      3829
Logged by:          Boonchai
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.3 beta 4
Operating system:   windows XP
Description:        Wrong index reporting from pgAdmin III (v1.8.0 rev
6766-6767)
Details: 

I created a table by

CREATE TABLE test_desc
(
  id integer,
  f1 character(10),
  f2 character(20)
)

case 1 : 
Created index by

CREATE INDEX test_desc_idx1
  ON test_desc
  USING btree
  (f1, f2 desc)

but pgAdmin reported like this

CREATE INDEX test_desc_idx
  ON test_desc
  USING btree
  (f1 DESC, f2 DESC)


case 2:
Created another index by

CREATE INDEX test_desc_idx2
  ON test_desc
  USING btree
  (f1 desc, f2);

but pgAdmin reported

CREATE INDEX test_desc_idx2
  ON test_desc
  USING btree
  (f1 DESC,  DESCf2);

Anyway, these 2 indexes are corrected, seen from pg_indexes.

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