Thread: 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