From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: log level of "drop cascade" lists |
Date: | 2019-01-10 15:44:34 |
Message-ID: | ed89f8c4-5403-cada-3fb9-f16f8a8274a8@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/10/19 3:28 AM, Willy-Bas Loos wrote:
> 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
>
> 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"
>
> 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.
Hence:
1) BEGIN;
DROP schema myschema CASCADE;
ROLLBACK/COMMIT;
2) \d myschema.*
> 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
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-10 16:04:23 | Re: log level of "drop cascade" lists |
Previous Message | Laurenz Albe | 2019-01-10 14:44:11 | Re: Error on Windows |