| 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(-)
| 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. |