Re:Postgres gets support for upsert
by ryan0x00 on Friday May 08, 2015 @12:15AM
(#9509935)
i've seen a system in mysql do "insert on duplicate key update" for ages, so this is that same pattern?
[ Parent
| on HN ]
Yeah, it is the same as INSERT ... ON DUPLICATE KEY UPDATE, and similar to REPLACE in MySQL. Exciting to see it in Postgres!
I think the way MySQL works in doing "INSERT ... ON DUPLICATE KEY UPDATE" is to delete the old row and insert a new row if there's an auto incremental column (mostly it's ID column). Being curious if Postgres works the same way in this regard.
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.
No, the auto increment columns are maintained as is.