| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Jordan Hurwich <jhurwich(at)pulsasensors(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org, Gautam Bellary <gautam(at)pulsasensors(dot)com> |
| Subject: | Re: Issue Supporting Emojis in Full Text Search on Ubuntu |
| Date: | 2020-07-02 07:43:53 |
| Message-ID: | 6b6d86047189104288aa78aaf345cbf7323d2f61.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jialun Zhang | 2020-07-03 19:12:08 | Why do we have checkPointCopy in ControlFileData? |
| Previous Message | Bzzzz | 2020-07-01 22:31:16 | Re: Issue Supporting Emojis in Full Text Search on Ubuntu |