No, that's how REPLACE works -- which is a complete pain to be honest! INSERT .....

		girvo on May 9, 2015 \| parent \| context \| favorite \| on: Postgres gets support for upsert No, that's how REPLACE works -- which is a complete pain to be honest! INSERT ... UPDATE works the way you'd hope it would, and keeps the auto inc columns correct.