pgsql: tsearch: use database default collation for parsing.

From: Jeff Davis <jdavis(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: tsearch: use database default collation for parsing.
Date: 2025-10-21 16:33:57
Message-ID: E1vBFJ7-002o5Q-1o@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

tsearch: use database default collation for parsing.

Previously, tsearch used the database's CTYPE setting, which only
matches the database default collation if the locale provider is libc.

Note that tsearch types (tsvector and tsquery) are not collatable
types. The locale affects parsing the original text, which is a lossy
process, so a COLLATE clause on the already-parsed value would not
make sense.

Reviewed-by: Peter Eisentraut <peter(at)eisentraut(dot)org>
Discussion: https://postgr.es/m/0151ad01239e2cc7b3139644358cf8f7b9622ff7.camel@j-davis.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e113f9c102b7e2462facf0ecffc97f8093efed54

Modified Files
--------------
src/backend/tsearch/ts_locale.c | 40 ++++++++--------------
src/backend/tsearch/wparser_def.c | 71 +++++++--------------------------------
2 files changed, 27 insertions(+), 84 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2025-10-21 17:24:25 pgsql: Update .abi-compliance-history file.
Previous Message Nathan Bossart 2025-10-21 15:06:00 pgsql: Add previous commit to .git-blame-ignore-revs.