From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: Wednesday, October 19, 2016 5:35 PM
To: Alex Ignatov (postgrespro)
Cc: Tom Lane ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
On Wed, Oct
16 4:31 PM
> To: Alex Ignatov (postgrespro)
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Drop user cascade
>
> "Alex Ignatov \(postgrespro\)" writes:
> > Why do Postgres have no such functionality as DROP USER CASCADE? Is
> > there any reasons in tha
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesday, October 19, 2016 4:31 PM
To: Alex Ignatov (postgrespro)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
"Alex Ig
"Alex Ignatov \(postgrespro\)" writes:
> Why do Postgres have no such functionality as DROP USER CASCADE? Is there
> any reasons in that absence?
The short answer is that DROP USER couldn't reach across databases to get
rid of owned objects in other databases. See
https://www.postgresql.org/do
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Wednesday, October 19, 2016 1:53 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
Alex Ignatov (postgrespro) schrieb am
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?
Yo
