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

The Post Office <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ilan@tzirechnoy.com
Date: 2021-11-20T11:49:20Z
Lists: 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

Commits

  1. Fix SP-GiST scan initialization logic for binary-compatible cases.