Alex Ignatov (postgrespro) schrieb am 19.10.2016 um 12:26:
> Hello!
>
> Why we can DROP TABLE CASCADE, DROP VIEW CASCADE, DROP SEQUENCE CASCADE but we can’t DROP USER/ROLE CASCADE?
>
> Why do Postgres have no such functionality as DROP USER CASCADE? Is there any reasons in that absence?
You can do
drop owned by user_name;
drop user user_name;
Thomas