-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Thomas Kellerer Sent: Wednesday, October 19, 2016 1:53 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Drop user cascade 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general I know this commands thank yo =). To use them you need to invoke this command in all database because roles sit atop of PG database or you need to find DBs which has objects that depend on ROLE you want to delete. You can't do anything with objects in DB you are not connected -- Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
