Well, depending how you configure your cascade clearing the user table could have cleared all the other tables also :)
"on delete cascade"!
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.
Re:How I Fired Myself
by jasonswett on Wednesday February 27, 2013 @04:57PM
(#5295244)
Exactly!!!!
* No Foreign Keys
Attempting to clear the table should have just thrown a constraint violation error.