Re: [GENERAL] Drop user cascade

Subject: Re: [GENERAL] Drop user cascade On Wed, Oct 19, 2016 at 10:03 AM, Alex Ignatov (postgrespro) <a.igna...@postgrespro.ru <mailto:a.igna...@postgrespro.ru> > wrote: -Original Message- From: pgsql-general-ow...@postgresql.org <mailto:pgsql-general-ow...@pos

Re: [GENERAL] Drop user cascade

16 4:31 PM > To: Alex Ignatov (postgrespro) <a.igna...@postgrespro.ru> > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Drop user cascade > > "Alex Ignatov \(postgrespro\)" <a.igna...@postgrespro.ru> writes: > > Why do Postgres have no s

Re: [GENERAL] Drop user cascade

-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) <a.igna...@postgrespro.ru> Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL

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 that absence? The short answer is that DROP USER couldn't reach across databases to get rid of owned objects in other databases. See

Re: [GENERAL] Drop user cascade

-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

Re: [GENERAL] 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?