From: Pavel Luzanov <p.luzanov@postgrespro.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@postgresql.org
Subject: Re: RAISE INFO and client_min_messages
Date: Thu, 23 Mar 2017 18:55:07 +0300
Message-ID: <6d34658f-6fc6-b105-524f-8127356c33e0@postgrespro.ru> (raw)
In-Reply-To: <19771.1490279948@sss.pgh.pa.us>
References: <de688a42-115c-4b8c-754c-41f1e3755e15@postgrespro.ru>
<19771.1490279948@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
On 23.03.2017 17:39, Tom Lane wrote:
> Pavel Luzanov <p.luzanov@postgrespro.ru> writes:
>> When working with RAISE statement in PL/pgSQL, I found a strange
>> situation with client_min_messages.
>> According to the documentation, client_min_messages does not include the
>> value 'INFO'.
> Indeed. INFO messages cannot be suppressed by client_min_messages.
> The reason is that they are emitted by commands like VACUUM VERBOSE,
> where (presumably) the entire reason the user said VERBOSE is that
> she wanted to see those messages.
>
Now, the reason for such behavior is clear.
As for me, adding one sentence to the end of current description for
client_min_messages will make sence:
Controls which message levels are sent to the client. Valid values are
DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, LOG, NOTICE, WARNING, ERROR,
FATAL, and PANIC. Each level includes all the levels that follow it. The
later the level, the fewer messages are sent. The default is NOTICE.
Note that LOG has a different rank here than in log_min_messages. Also,
messages with INFO level are sent to the client with any value of this
parameter.
-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: p.luzanov@postgrespro.ru, tgl@sss.pgh.pa.us
Subject: Re: RAISE INFO and client_min_messages
In-Reply-To: <6d34658f-6fc6-b105-524f-8127356c33e0@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox