Horton

Thread

Commits

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

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

    The Post Office <noreply@postgresql.org> — 2021-11-20T11:49:20Z

    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

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

    Tom Lane <tgl@sss.pgh.pa.us> — 2021-11-20T17:10:21Z

    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