Re: How to get RAISE messges displayed?

Поиск
Список
Период
Сортировка
От stan
Тема Re: How to get RAISE messges displayed?
Дата
Msg-id 20190830223501.GA6854@panix.com
обсуждение исходный текст
Ответ на How to get RAISE messges displayed?  (stan <stanb@panix.com>)
Ответы Re: How to get RAISE messges displayed?  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: stan
Дата:
Сообщение: How to get RAISE messges displayed?
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Exclusion constraints on overlapping text arrays?