Re: invalid value for parameter "default_text_search_config": "public.pg" - Mailing list pgsql-general

From Les
Subject Re: invalid value for parameter "default_text_search_config": "public.pg"
Date
Msg-id CAKXe9UDz1qcEJN1BTTqM6TPQT63q=WTM_zw29eqAccGkSfRPxQ@mail.gmail.com
Whole thread Raw
In response to Re: invalid value for parameter "default_text_search_config": "public.pg"  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: invalid value for parameter "default_text_search_config": "public.pg"  (Les <nagylzs@gmail.com>)
List pgsql-general

> SQL Error [22023]: ERROR: invalid value for parameter
> "default_text_search_config": "public.pg <http://public.pg>"
>    Where: while setting parameter "default_text_search_config" to
> "public.pg <http://public.pg>" parallel worker

What client are you using to run the commands?

I just checked and it also throws this error when I execute the following SELECT from plain psql:

 select
                        pft.id as file_type_id,
                        pft.code as file_type_code,
                        pfs.id as file_status_id,
                        pfs.code as file_status_code,
                        count(pf.id) as cnt
                    from
                        product.product_file pf
                        inner join product.product p on p.id=pf.product_id
                        inner join product.product_file_type pft  on pft.id = pf.product_file_type_id
                        inner join product.product_file_status pfs  on pfs.id = pf.product_file_status_id
                    group by
                        pft.id, pfs.id;
ERROR:  invalid value for parameter "default_text_search_config": "public.pg"
CONTEXT:  while setting parameter "default_text_search_config" to "public.pg"
parallel worker

 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: invalid value for parameter "default_text_search_config": "public.pg"
Next
From: Les
Date:
Subject: Re: invalid value for parameter "default_text_search_config": "public.pg"