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

bugfix: dlgIndex column order

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: bugfix: dlgIndex column order
Date: 2009-05-15 07:22:57
Message-ID: 20090515161746.7F24.4125B4E5@gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi, all

Bug fix:
    only when index's type is btree, user can set column order.
reported by: Obe, Regina

> I see that the new version of PgAdmin now automatically puts in for
> CREATE INDEX a
> 
> the new NULLS FIRST / LAST clause for PostgreSQL 8.4.
> 
> Unfortunately when you try to use this for a gist index -- it generates
> something like this
> 
> CREATE INDEX mytable_idx_the_geom
>    ON mytable USING gist (poi_geom ASC NULLS LAST);
> 
> Which generates an error from PostgreSQL like this.
> 
>  access method "gist" does not support ASC/DESC options
> 
> There doesn't seem to be a way to turn this off except by explicitly
> editing the SQL statement to remove the ASC clause.  Can we have it not
> enabled by default or if we must -- allow this to be unchecked.
> 
> Thanks,
> Regina

-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn

Attachment: dlgIndex.zip
Description: application/x-zip-compressed (2.0 KB)

Responses

pgadmin-hackers by date

Next:From: svnDate: 2009-05-15 07:48:17
Subject: SVN Commit by dpage: r7868 - trunk/pgadmin3/pgadmin/include
Previous:From: Heikki LinnakangasDate: 2009-05-14 17:34:21
Subject: Re: Ranked Rather Than Ordered

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