Re: BUG #17294: spgist doesn't support varchar, only text type fields.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17294: spgist doesn't support varchar, only text type fields.
Дата
Msg-id 3175925.1637428221@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #17294: spgist doesn't support varchar, only text type fields.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> ilank=*> create table test (a text, b varchar);
> CREATE TABLE
> ilank=*> create index on test using spgist (b);
> ERROR:  compress method must be defined when leaf type is different from
> input type

Ugh.  Fails for domains over text, too, which it shouldn't.
Will fix, thanks for the report!

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17295: Different query plan with Index Only Scan and Bitmap Index Scan.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore depending on user functions