| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Florian Fuchs <fuchsfl(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Configure StopWords in full text search without a configuration file? |
| Date: | 2022-11-17 15:23:02 |
| Message-ID: | a565b15a6a63f3c07bb035380612f4490c563b2c.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2022-11-17 at 14:30 +0100, Florian Fuchs wrote:
> is it possible to configure a StopWord list without a file in the
> configuration-filesystem of postgres?
> (StopWord: https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-STOPWORDS)
No, this is impossible.
> By default, the StopWord files are stored at $SHAREDIR/tsearch_data/*.stop - I don't
> have access to the filesystem, so I need to configure custom StopWords
> within my database/schema (SQL-Access).
>
> Is this somehow possible?
If you have superuser access or have a user that is a member of
"pg_write_server_files", you could write the stopword file via SQL.
Other than that, I see no possibility.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Вадим Самохин | 2022-11-17 15:45:02 | Postgresql 11.3 doesn't use gist index on polygon column |
| Previous Message | Murillo corvino rocha | 2022-11-17 15:11:10 | session_user different from current_user after normal login |