365
submitted 2 years ago* (last edited 2 years ago) by [email protected] to c/[email protected]

"UPDATE table_name SET w = $1, x = $2, z = $4 WHERE y = $3 RETURNING *",

does not do the same as

"UPDATE table_name SET w = $1, x = $2, y = $3, z = $4 RETURNING *",

It's 2 am and my mind blanked out the WHERE, and just wanted the numbers neatly in order of 1234.

idiot.

FML.

you are viewing a single comment's thread
view the rest of the comments
[-] [email protected] 109 points 2 years ago* (last edited 2 years ago)

This is a hard lesson to learn. From now on, my guess is you will have dozens of backups.

[-] [email protected] 64 points 2 years ago

And a development environment. And not touch production without running the exact code at least once and being well slept.

[-] [email protected] 8 points 2 years ago

Fuck that, get shit housed and still do it right. That's a pro.

[-] [email protected] 19 points 2 years ago

That's not pro, that's just reckless gambling.

[-] [email protected] 3 points 2 years ago

Totally right! You must set yourself up so a fool can run in prod and produce the expected result. Which is the purpose of a test env.

load more comments (1 replies)
load more comments (1 replies)
load more comments (8 replies)
this post was submitted on 11 Oct 2023
365 points (97.7% liked)

Programming

21621 readers
199 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities [email protected]



founded 2 years ago
MODERATORS