Re: BUG #17294: spgist doesn't support varchar, only text type fields. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17294: spgist doesn't support varchar, only text type fields.
Date
Msg-id 3175925.1637428221@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17294: spgist doesn't support varchar, only text type fields.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17295: Different query plan with Index Only Scan and Bitmap Index Scan.
Next
From: Tom Lane
Date:
Subject: Re: pg_restore depending on user functions