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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17294: spgist doesn't support varchar, only text type fields.
Дата
Msg-id 17294-8f6c7962ce877edc@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17294: spgist doesn't support varchar, only text type fields.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17294
Logged by:          Ilya Anfimov
Email address:      ilan@tzirechnoy.com
PostgreSQL version: 14.1
Operating system:   Devuan GNU/linux beowulf
Description:

I found that on 14.0 and 14.1 the server gives the error when I try to
create spgist index on a varchar field.
Note, that on 9.4 - 13 servers this test worked fine.

ilank=*> create table test (a text, b varchar);
CREATE TABLE
ilank=*> create index on test using spgist (a);
CREATE INDEX
ilank=*> create index on test using spgist (b);
ERROR:  compress method must be defined when leaf type is different from
input type


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #17288: PSQL bug with COPY command (Windows)
Следующее
От: Dmitry Koval
Дата:
Сообщение: Re: BUG #17288: PSQL bug with COPY command (Windows)