Y
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
Xylakant
4781 days ago
TRUNCATE TABLE users; should work and will have similar disastrous effects.
link
wiredfool
4781 days ago
You can revoke truncate from public.
link
Xylakant
4781 days ago
Oh, sure. I'll just do "DELETE FROM users" and forget about the WHERE clause. Same effect.
link