ifnotexists in postgres considered harmful

I was a big fan of IF NOT EXISTS, but seems like it has a bad side that I didn’t think deep enough about :) See Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL