Re: [GENERAL] dropping role w/dependent objects - Mailing list pgsql-patches

From Tom Lane
Subject Re: [GENERAL] dropping role w/dependent objects
Date
Msg-id 8029.1178926844@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] dropping role w/dependent objects  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [GENERAL] dropping role w/dependent objects  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Sample output to the client (note: in this test, MAX_REPORTED_DEPS is
> set to 10).
> ...
> foo=# drop user foo;
> ERROR:  role "foo" cannot be dropped because some objects depend on it
> DETAIL:  owner of tablespace foo
> owner of table a100
> owner of table a99
> owner of table a98
> owner of table a97
> owner of table a96
> owner of table a95
> owner of table a94
> owner of table a93
> owner of table a92
> 5 objects in database bar
> and other 95 objects reported to the server log

"and 95 other objects", please.

> Whereas the postmaster log gets

Nothing about the objects in database bar?

            regards, tom lane

pgsql-patches by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Doc update for back-branches, CLUSTER and MVCC-safety
Next
From: Andrew Dunstan
Date:
Subject: Re: updated WIP: arrays of composites