Following the premise that database integrity should be handled by rules in the schema as much as possible, the automatic UPSERT whereby trying to create a record with the same unique key as a record that already exists does not trigger an INSERT error but automatically updates the existing record is pretty alien.
I really don't want to enforce this on business logic and I want the backend to do the work. Is there away to prevent the UPSERT?