Re: ERROR: could not determine which collation to use for string comparison

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rômulo Coutinho <romulo(at)supersim(dot)com(dot)br>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR: could not determine which collation to use for string comparison
Date: 2023-06-06 16:57:57
Message-ID: b88112f0db529d7319e2a7bb6435a972b0753424.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2023-06-06 at 11:42 -0300, Rômulo Coutinho wrote:
> We recently upgraded to Postgres 15.3. When running ANALYZE, we get the following message:
> ERROR:  could not determine which collation to use for string comparison
> HINT:  Use the COLLATE clause to set the collation explicitly.
>
> We have never seen this before. Could this be a bug?

Impossible to say without a way to reproduce.

Yours,
Laurenz Albe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message chap 2023-06-06 17:00:11 Re: Let's make PostgreSQL multi-threaded
Previous Message Tristan Partin 2023-06-06 16:52:25 Re: abi-compliance-checker