Hi,
(this is in version 9.4)
The SQL command DROP schema myschema CASCADE tells me that the full list of items that the drop cascades to is in the log, but it isn't.
messages on stdout:
...
drop cascades to table myschema.mytable
and 143 other objects (see server log for list)
DROP SCHEMA
and 143 other objects (see server log for list)
DROP SCHEMA
The log doesn't mention this at all, except
2019-01-10 12:10:45 CET ERROR: canceling autovacuum task
2019-01-10 12:10:45 CET CONTEXT: automatic analyze of table "myschema.mytable"
2019-01-10 12:10:45 CET CONTEXT: automatic analyze of table "myschema.mytable"
log_min_messages is on the default value, which is warning.
#log_min_messages = warning
At first glance, it seems logical that the list of dropped items is a "notice". But now that it seems that the cascade went further than i anticipated, it is of a greater significance to me than that.
Also, truncating the list in the message and referring to the log is not desirable IMHO if the default setting is to not log the list.
So long story short: i think it would be wise to set the log level of "drop cascade" lists to "warning".
Cheers,
--
Willy-Bas Loos
