PgAdmin 1.10 Beta 2 - can't create gist index against 8.4
От | Obe, Regina |
---|---|
Тема | PgAdmin 1.10 Beta 2 - can't create gist index against 8.4 |
Дата | |
Msg-id | 53F9CF533E1AA14EA1F8C5C08ABC08D205C5FA61@ZDND.DND.boston.cob обсуждение исходный текст |
Ответы |
Re: PgAdmin 1.10 Beta 2 - can't create gist index against 8.4
|
Список | pgadmin-support |
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.
В списке pgadmin-support по дате отправления: