tsearch: use database default collation for parsing.
authorJeff Davis <jdavis@postgresql.org>
Tue, 21 Oct 2025 16:31:49 +0000 (09:31 -0700)
committerJeff Davis <jdavis@postgresql.org>
Tue, 21 Oct 2025 16:31:49 +0000 (09:31 -0700)
commite113f9c102b7e2462facf0ecffc97f8093efed54
tree5aa3712423242e0a045b295f3a776e4e0afb6adb
parent776c2c2ae2d3ba7d9b5d7d780df67af1924e7591
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@eisentraut.org>
Discussion: https://postgr.es/m/0151ad01239e2cc7b3139644358cf8f7b9622ff7.camel@j-davis.com
src/backend/tsearch/ts_locale.c
src/backend/tsearch/wparser_def.c