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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
dlgIndex.zip application/x-zip-compressed 2.0 KB

Responses

Browse pgadmin-hackers by date

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