Postgres gets support for upsert
git.postgresql.org
Postgres gets support for upsert
1–10 of 114 posts
Re: Postgres gets support for upsert
#2So excited about upserts in Postgres!
This was the most requested feature in PostgreSQL: https://postgresql.uservoice.com/forums/21853-general
Re: Postgres gets support for upsert
#3This is actually huge. A common problem that arises when you write applications is you want to INSERT if key does not exist else UPDATE. The right way of doing this without an upsert is using a transaction. However this will make life easier as you can do it directly in one SQL statement.
Re: Postgres gets support for upsert
#4Seriously, IIRC the wiki page for this feature was like 5 years old. I'll have some statements I'll be very glad to update as soon as this is released.
I was so surprised when I ran into the lack of this feature as I'd had it on both MSSQL and MySQL.
Re: Postgres gets support for upsert
#5This is actually huge. A common problem that arises when you write applications is you want to INSERT if key does not exist else UPDATE. The right way of doing this without an upsert is using a transaction. However this will make life easier as you can do it directly in one SQL statement.
i've seen a system in mysql do "insert on duplicate key update" for ages, so this is that same pattern?
Re: Postgres gets support for upsert
#6Yet another reason why I absolutely love Postgres. It might have taken four years, but we finally got what many of us have been asking for. Nothing ruined my day more than having to write insert-update loops, I am beyond ecstatic for this.
Re: Postgres gets support for upsert
#7Yes! it's about bloody time.
Re: Postgres gets support for upsert
#8This is actually huge. A common problem that arises when you write applications is you want to INSERT if key does not exist else UPDATE. The right way of doing this without an upsert is using a transaction. However this will make life easier as you can do it directly in one SQL statement.
i've seen a system in mysql do "insert on duplicate key update" for ages, so this is that same pattern?
Yeah, it is the same as INSERT ... ON DUPLICATE KEY UPDATE, and similar to REPLACE in MySQL. Exciting to see it in Postgres!
Re: Postgres gets support for upsert
#9I think I squealed with delight when I read this title. This is really a great addition, and will simplify so much of my code once I'm able to upgrade.
I try not to think too deeply about all the DB internals (some people are much smarter than me about this stuff), but clearly there are a lot of things that need maintained internally to make this correct, so kudos to all the people who contributed to this.
Re: Postgres gets support for upsert
#10Which version of Postgres will this land in?