I'll add another one: \* No Foreign Keys Attempting to clear the table should ha... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

mbell on Feb 27, 2013 | parent | context | favorite | on: How I Fired Myself

I'll add another one:

* No Foreign Keys

Attempting to clear the table should have just thrown a constraint violation error.

eloisant on Feb 28, 2013 | [–]

Well, depending how you configure your cascade clearing the user table could have cleared all the other tables also :)

"on delete cascade"!

mbell on Feb 28, 2013 | | [–]

True on MySql with InnoDB, wouldn't be true with postgres.

You'd have to use TRUNCATE CASCADE on postgres to avoid the foreign key error.

jasonswett on Feb 27, 2013 | [–]

Exactly!!!!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact