Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-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

In response to

Responses

pgsql-bugs by date

Next:From: Zdenek KotalaDate: 2007-12-19 10:45:28
Subject: Re: Bug (#3484) - Invalid page header again
Previous:From: Alexander SteffensDate: 2007-12-19 09:57:53
Subject: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)

pgadmin-support by date

Next:From: NikhilSDate: 2007-12-19 11:06:06
Subject: Re: BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)
Previous:From: Pavel StehuleDate: 2007-12-19 09:29:33
Subject: Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group