From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ilan@tzirechnoy.com
Subject: BUG #17294: spgist doesn't support varchar, only text type fields.
Date: Sat, 20 Nov 2021 11:49:20 +0000
Message-ID: <17294-8f6c7962ce877edc@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, ilan@tzirechnoy.com
Subject: Re: BUG #17294: spgist doesn't support varchar, only text type fields.
In-Reply-To: <17294-8f6c7962ce877edc@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox