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 删除它……很有帮助。