From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>
Cc: pgsql-docs@postgresql.org
Subject: Re: RAISE INFO and client_min_messages
Date: Thu, 23 Mar 2017 10:39:08 -0400
Message-ID: <19771.1490279948@sss.pgh.pa.us> (raw)
In-Reply-To: <de688a42-115c-4b8c-754c-41f1e3755e15@postgrespro.ru>
References: <de688a42-115c-4b8c-754c-41f1e3755e15@postgrespro.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
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.
I do not recommend using INFO in "RAISE" except in cases similar
to that one.
regards, tom lane
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
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: tgl@sss.pgh.pa.us, p.luzanov@postgrespro.ru
Subject: Re: RAISE INFO and client_min_messages
In-Reply-To: <19771.1490279948@sss.pgh.pa.us>
* 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