Hello
it's pgAdmin bug. please report it there
Regards
Pavel Stehule
On 19/12/2007, Boonchai <boonchai@xsidekick.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3829
> Logged by: Boonchai
> Email address: boonchai@xsidekick.com
> 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
>