| 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: | Whole Thread | Raw Message | 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
| 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? |