Re: invalid value for parameter "default_text_search_config": "public.pg"

From: Les <nagylzs(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: invalid value for parameter "default_text_search_config": "public.pg"
Date: 2023-07-21 19:57:45
Message-ID: CAKXe9UAJEc5viTV7FDtayQ6rH6bKFZnJCQa_muQh1-UjVyOf6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> However, the parallel worker should just be absorbing the same
> configuration settings your main session is using. So what remains
> to be explained is why you aren't seeing the same complaint when
> starting a fresh session. It might be useful to look at the
> output of
>
> show default_text_search_config;
>
> and
>
> select * from pg_file_settings where name = 'default_text_search_config';
>
> psql (15.3 (Debian 15.3-1.pgdg110+1))
Type "help" for help.

mydatabase=# show default_text_search_config;
default_text_search_config
----------------------------
public.pg
(1 row)

mydatabase=# select * from pg_file_settings where name =
'default_text_search_config';
sourcefile | sourceline | seqno |
name | setting | applied | error
--------------------------------------------+------------+-------+----------------------------+-----------+---------+------------------------------
/opt/postgresql/data/conf.d/06_locale.conf | 17 | 24 |
default_text_search_config | public.pg | f | setting could not be
applied
(1 row)

mydatabase=#

I'm not sure what applied="public.pg", error="setting could not be applied"
means. I can change it in the config file, no problem. I just would like to
know if this is a simple configuration error, or a software installation
error. (Is public.pg a built-in config that should always exist?)

Regards,

Laszlo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-07-21 21:09:15 Re: invalid value for parameter "default_text_search_config": "public.pg"
Previous Message Tom Lane 2023-07-21 19:31:53 Re: invalid value for parameter "default_text_search_config": "public.pg"