BUG #17294: spgist doesn't support varchar, only text type fields.
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
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