Hacker News new | ask | show | jobs
by wiredfool 4781 days ago
You can't drop a database on postgres if anyone is connected to it, which is likely the case on production.
1 comments

TRUNCATE TABLE users; should work and will have similar disastrous effects.
You can revoke truncate from public.
Oh, sure. I'll just do "DELETE FROM users" and forget about the WHERE clause. Same effect.