On 7/20/23 22:25, Les wrote:
> I try to execute this on a very simple table, in a production database:
>
> alter table product.product add proc_order int8;
> create index idx_product_proc_order_status on product.product(proc_order
> nulls last, product_status_id /* this has type uuid */ );
>
> and I get this error:
>
> 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 have been using this database for many weeks now, and never got a
> similar message. I don't understand how the creation of an index on an
> int8 and an uuid field is related to full text search.
>
> Thanks,
>
> Laszlo
>
--
Adrian Klaver
adrian.klaver@aklaver.com