How to get RAISE messges displayed?

On Fri, Aug 30, 2019 at 06:22:14PM -0400, stan wrote:

OK, I am doing enough of this to start using some debug error messages.

I put the following in a function declaration:

RAISE notice 'Called with %', $1 ;

But, when I call the function I do not see anything. I edited postgresql.conf

Like this:

client_min_messages = notice
#client_min_messages = notice # values in order of decreasing detail:

Event though it looked like this should be the default.

restarted Postgres with:

/etc/init.d/postgresql restart

But I still do not see this, or see it in the log when I call this function.

Ubuntu 18.04 a Postgresql 11 if that matters.

Got it working.

Not 100% sure what I had wrong.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

On Sat, Aug 31, 2019 at 12:35 AM stan <stanb@panix.com> wrote:

Got it working.

Not 100% sure what I had wrong.

You can also do, in your session:
set client_min_messages to notice;
without having to change it in the configuration (for all sessions).

Luca