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  (Quan Zongliang <quanzongliang@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kevin Field
Дата:
Сообщение: Re: pgAdmin3 1.10 beta3 on win32 clipboard bug
Следующее
От: chris.sullivan@l-3com.com
Дата:
Сообщение: i need help its not working