Invalid column reference: 7 ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

This has gone quite a while with no response. I’m seeing it too. Any solution?