Horton
Menu

Re: Corruption or wrong results with 14.10?

Torsten Förtsch <tfoertsch123@gmail.com>

View thread
From: Torsten Förtsch <tfoertsch123@gmail.com>
To: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-11-23T15:34:13Z
Lists: pgsql-general 
On Thu, Nov 23, 2023 at 2:29 PM Daniel Westermann (DWE) <
daniel.westermann@dbi-services.com> wrote:

> smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group
> by  crart_id, chemin having count(*) > 1;
>   crart_id   | chemin | count
> -------------+--------+-------
>  35054630000 | @      |     2
>   4737310000 | @      |     2
>  10632380000 | @      |     2
>  14680880000 | @      |     2
>   4627230000 | @      |     2
>  10993780000 | @      |     2
> ....
>
> I think I know what I have to do.
>

If you have moved the database from a system with glibc <2.28 to >=2.28,
that could be the reason.

https://wiki.postgresql.org/wiki/Collations