From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Boonchai <boonchai(at)xsidekick(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767) |
Date: | 2007-12-19 10:03:41 |
Message-ID: | 4768EC7D.6070402@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-bugs |
Pavel Stehule wrote:
> Hello
>
> it's pgAdmin bug. please report it there
Actually it doesn't appear to be...
Using the OPs example code on 8.3 beta 4:
>> CREATE INDEX test_desc_idx1
>> ON test_desc
>> USING btree
>> (f1, f2 desc)
>>
>> CREATE INDEX test_desc_idx2
>> ON test_desc
>> USING btree
>> (f1 desc, f2);
postgres=# select pg_get_indexdef('test_desc_idx1'::regclass, 0, true);
pg_get_indexdef
--------------------------------------------------------------------
CREATE INDEX test_desc_idx1 ON test_desc USING btree (f1, f2 DESC)
(1 row)
postgres=# select pg_get_indexdef('test_desc_idx1'::regclass, 1, true);
pg_get_indexdef
-----------------
f1 DESC
(1 row)
postgres=# select pg_get_indexdef('test_desc_idx1'::regclass, 2, true);
pg_get_indexdef
-----------------
f2 DESC
(1 row)
postgres=# select pg_get_indexdef('test_desc_idx2'::regclass, 0, true);
pg_get_indexdef
--------------------------------------------------------------------
CREATE INDEX test_desc_idx2 ON test_desc USING btree (f1 DESC, f2)
(1 row)
postgres=# select pg_get_indexdef('test_desc_idx2'::regclass, 1, true);
pg_get_indexdef
-----------------
f1 DESC
(1 row)
postgres=# select pg_get_indexdef('test_desc_idx2'::regclass, 2, true);
pg_get_indexdef
-----------------
DESCf2
(1 row)
Looks like pg_get_indexdef is unwell :-(
/D
From | Date | Subject | |
---|---|---|---|
Next Message | NikhilS | 2007-12-19 11:06:06 | Re: BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767) |
Previous Message | Pavel Stehule | 2007-12-19 09:29:33 | Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767) |
From | Date | Subject | |
---|---|---|---|
Next Message | Zdenek Kotala | 2007-12-19 10:45:28 | Re: Bug (#3484) - Invalid page header again |
Previous Message | Alexander Steffens | 2007-12-19 09:57:53 | Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?) |