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.
