On Wed, 2020-07-01 at 14:56 -0700, Jordan Hurwich wrote:
> You were completely right to question our previous manipulation of the pg_database entry,
> and after revisiting that we were able to address the issue by updating datcollate and
> datctype to "C" - ts_debug() now recognizes emoji characters as "word" characters and
> text search functionality is behaving as expected.
If you manually modified "pg_database", you probably broke your database.
At the very least, REINDEX all indexes that contain strings. I don't know
if there could be other problems.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com