Обсуждение: PgAdmin 1.10 Beta 2 - can't create gist index against 8.4

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

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

> 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, Rigina.

The PostgreSQL documentation mentioned:
For index methods that support ordered scans (currently, only B-tree),
the optional clauses ASC, DESC, NULLS FIRST, and/or NULLS LAST can be specified
to reverse the normal sort direction of the index.

This is my mistake.
I will fix it ASAP.

-----------------------------------------------
Quan Zongliang
quanzongliang@gmail.com
CIT JAPAN: http://www.cit.co.jp
CIT CHINA: http://www.citbj.com.cn