INSERT INTO ... ON CONFLICT ... DO UPDATE SET https://www.postgresql.org/docs/9.6/static/sql-insert.html#SQL-ON-CONFLICT … (Postgres "upsert")
-
-
Replying to @Croaky
one thing to watch out for with auto-incr cols; the sequence will be ascending BUT we saw gaps in the numbers which wasn't ideal
1 reply 0 retweets 1 like -
Bigint4Lyfe
1 reply 0 retweets 0 likes -
yah that's how we caught it... the col hit max int within the first week :/
1 reply 0 retweets 0 likes -
Clearly you weren't using Rails 5+
1 reply 0 retweets 1 like -
Replying to @sgrif
Ah, cool! http://www.mccartie.com/2016/12/05/rails-5.1.html … Hadn't noticed that before, nice work all.
1 reply 0 retweets 0 likes
Replying to @Croaky
All my fav features are the ones you'll never notice if we did our job right. (Preventing accidentally dropping prod db another like this)
11:23 AM - 31 Aug 2017
from Ottawa, Ontario
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.