Yes I already read that when researching for upserts in each database engine. And this article says that postgresql does not have upserts and wishes there was one. So I'm not sure what you expect here?
The workaround, that I already implemented as fallback, is to use DELETE -> INSERT