Corrupt indexes in PG12, how do I fix?

[pfaffman (Jay Pfaffman)]

That could be. I think that the leading % is enough, but I could be wrong.

[neounix (Dark Matter)]

@itsbhanusharma

I think ilike would be needed

Correct.

See, for example:

[michaeld (Michael - Communiteq)]

But… all settings are in lowercase, so just using lowercase in the query does not need ilike ?

[codinghorror (Jeff Atwood)]

まあ、誰かの気分が良くなるなら、私も同じ問題に遭遇しました！

Caused by:
PG::UniqueViolation: ERROR:  could not create unique index "index_incoming_referers_on_path_and_incoming_domain_id_c_ccnew2"
DETAIL:  Key (path, incoming_domain_id)=(/_, 1169) is duplicated.

上記の指示――コンテナに入り、Postgresを起動し、不正なデータをクエリし、IDで削除する――は役に立ちました。