News for hackers. Stuff that matters.

A comment on How I Fired Myself. Parent comment

Re:How I Fired Myself by eloisant on Thursday February 28, 2013 @04:28AM (#5297893)
Well, depending how you configure your cascade clearing the user table could have cleared all the other tables also :)

"on delete cascade"!

[ Parent | on HN ]
Re:How I Fired Myself by mbell on Thursday February 28, 2013 @11:29AM (#5299378)
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.

[ Parent | on HN ]