Learn More
Resend Email
8
rantbook
5y

Official Postgres docs:

"If you simply write:

DELETE FROM products;
then all rows in the table will be deleted! Caveat programmer."

"Caveat programmer"... "Cavea...." "Cave..."

Someone out there is reading this with bloodshot eyes, 3 am, stuck reading this on repeat and prefers that The Ring movie is true and would rather take that...

rant

docks-mock-devs
Favorite
Ranter
Comments
  • 2
    5y
    ALWAYS use a where clause.
  • 1
    5y
    Our production user just has no ability to DELETE (on most tables). That's where softDeletes comes in.
  • 1
    5y
    But that's normal db behavior?
  • 1
    5y
    @Root you can do it in Oracle, too. It's a great shortcut... to really ruin your day.
  • 1
    5y
    @iAmNaN You can do it in every database as far as i'm aware 😋
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment