| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-patches(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] dropping role w/dependent objects |
| Date: | 2007-05-11 23:40:44 |
| Message-ID: | 8029.1178926844@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Alvaro Herrera <alvherre(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-05-11 23:45:32 | Re: updated WIP: arrays of composites |
| Previous Message | Andrew Dunstan | 2007-05-11 23:38:20 | Re: updated WIP: arrays of composites |