Re: Missing INFO on client_min_messages

Em dom., 24 de nov. de 2024 às 13:57, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escreveu:

> Yeah. You can set it to INFO if you like, but the behavior is not
> different from setting it to NOTICE.

No, I don't think they have the same behavior.
If you set client_min_messages to Error then notice will not be sent, info
will will be sent anyway

postgres=# set client_min_messages = Notice;
SET
postgres=# do $$begin raise INFO 'Sending to client INFO';end;$$;
INFO: Sending to client INFO
DO
postgres=# do $$begin raise NOTICE 'Sending to client NOTICE';end;$$;
NOTICE: Sending to client Notice
DO

postgres=# set client_min_messages = error;
SET
postgres=# do $$begin raise INFO 'Sending to client INFO';end;$$;
INFO: Sending to client INFO
DO
postgres=# do $$begin raise NOTICE 'Sending to client NOTICE';end;$$;
DO

regards
Marcos