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

From: Les <nagylzs(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: invalid value for parameter "default_text_search_config": "public.pg"
Date: 2023-07-21 18:51:02
Message-ID: CAKXe9UDz1qcEJN1BTTqM6TPQT63q=WTM_zw29eqAccGkSfRPxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Les 2023-07-21 18:59:08 Re: invalid value for parameter "default_text_search_config": "public.pg"
Previous Message Adrian Klaver 2023-07-21 15:28:48 Re: invalid value for parameter "default_text_search_config": "public.pg"