Postgres Pro
Downloads
Home   >   mailing lists

Re: Drop user cascade - Mailing list pgsql-general

From Tom Lane
Subject Re: Drop user cascade
Date
Msg-id 24559.1476883887@sss.pgh.pa.us
Whole thread Raw
In response to Drop user cascade  ("Alex Ignatov \(postgrespro\)" <a.ignatov@postgrespro.ru>)
Responses Re: Drop user cascade  ("Alex Ignatov \(postgrespro\)" <a.ignatov@postgrespro.ru>)
List pgsql-general
Tree view 
"Alex Ignatov \(postgrespro\)" <a.ignatov@postgrespro.ru> 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/docs/9.6/static/role-removal.html

            regards, tom lane

pgsql-general by date:

Previous
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Re: journaled FS and and WAL
Next
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Re: Drop user cascade