How to get RAISE messges displayed?

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to get RAISE messges displayed?
Date: 2019-08-30 22:22:14
Message-ID: 20190830222214.GE12804@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-08-30 22:35:01 Re: How to get RAISE messges displayed?
Previous Message stan 2019-08-30 22:12:25 Re: Returning a table from a function, that requires multiple selects?