Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] raise notice question

[GENERAL] raise notice question

From
ProPAAS DBA
Date:
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?


Thanks in advance

Re: [GENERAL] raise notice question

From
Pavel Stehule
Date:
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
 

Thanks in advance





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

Re: [GENERAL] raise notice question

From
Tom Lane
Date:
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

Re: [GENERAL] raise notice question

From
Kevin Grittner
Date:
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