Re: Missing INFO on client_min_messages - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Missing INFO on client_min_messages
Date
Msg-id CAB-JLwZvFo3rQoKk4BdE1QmnT3dHDQMV7Zpis1J_8Vqj2s2sSQ@mail.gmail.com
Whole thread Raw
In response to Re: Missing INFO on client_min_messages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Em dom., 24 de nov. de 2024 às 13:57, Tom Lane <tgl@sss.pgh.pa.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

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Conflict detection for update_deleted in logical replication
Next
From: Yash Jain
Date:
Subject: What db objects can only be created with superuser?