pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17294: spgist doesn't support varchar, only text type fields.
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2021-11-20 f4e7ae2b8a 6d07cbc509 Fix SP-GiST scan initialization logic for binary-compatible cases.
* BUG #17294: spgist doesn't support varchar, only text type fields.
@ 2021-11-20 11:49 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-11-20 11:49 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: ilan@tzirechnoy.com
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17294: spgist doesn't support varchar, only text type fields.
@ 2021-11-20 17:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2021-11-20 17:10 UTC (permalink / raw)
To: ilan@tzirechnoy.com; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-11-20 17:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-20 11:49 BUG #17294: spgist doesn't support varchar, only text type fields. PG Bug reporting form <noreply@postgresql.org>
2021-11-20 17:10 ` Tom Lane <tgl@sss.pgh.pa.us>
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