BUG #17294: spgist doesn't support varchar, only text type fields. - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17294: spgist doesn't support varchar, only text type fields.
Date
Msg-id 17294-8f6c7962ce877edc@postgresql.org
Whole thread Raw
Responses Re: BUG #17294: spgist doesn't support varchar, only text type fields.
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #17288: PSQL bug with COPY command (Windows)
Next
From: Dmitry Koval
Date:
Subject: Re: BUG #17288: PSQL bug with COPY command (Windows)