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 |
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 |