raise notice question

Hi

2017-01-14 17:29 GMT+01:00 ProPAAS DBA <dba@propaas.com>:

Is it possible to execute a raise notice without the "Notice" keyword
being part of the output, or is there another construct that allows writing
to output as simple informational text (without any sort of NOTICE,
WARNING, etc being part of the output?

I am not sure if I understand to query well. If you ask on possibility to
set a level of RAISE statement as dynamic parameter, then the reply is not.

The log level - DEBUG, .. NOTICE, WARNING, ERROR is required field of
PostgreSQL log/error processing system.

What do you want?

Regards

Pavel

ProPAAS DBA <dba@propaas.com> writes:

Is it possible to execute a raise notice without the "Notice" keyword
being part of the output, or is there another construct that allows
writing to output as simple informational text (without any sort of
NOTICE, WARNING, etc being part of the output?

This is a matter for how your client code presents the message data.
So far as psql is concerned, the answer would be "no", but a custom
application could deconstruct the notice message however it wanted.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On Sat, Jan 14, 2017 at 11:15 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

ProPAAS DBA <dba@propaas.com> writes:

Is it possible to execute a raise notice without the "Notice" keyword
being part of the output

This is a matter for how your client code presents the message data.
So far as psql is concerned, the answer would be "no", but a custom
application could deconstruct the notice message however it wanted.

It wouldn't be crazy to provide a way in psql to suppress the level only
for NOTICE. It would become much more important to be able to do so
(and perhaps do so by default) if we get stored procedures which can
return a complex result stream like TDS does. The series of literals
and results sets of different types is something which can be quite
useful to DBAs.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general