On Thu, Nov 23, 2023 at 2:29 PM Daniel Westermann (DWE) < daniel.westerm...@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
