Perform update and raise notice in Postgres Function
The problem can be, that level for messages is too high
so try this appproach


CREATE TABLE id ( &quot;id1&quot; INT)




INSERT INTO id VALUES (1)


1 rows affected




do
$$
declare
  newnumer int = 90;
begin
   
  UPDATE id SET id1 =  newnumer WHERE id1 = 1;
SET client_min_messages TO INFO;
  raise info   '&quot;NOTICE&quot; is the proper RAISE (Why not &quot;INFO&quot;?)' ;
        -- catch notification
      
end;
$$
language plpgsql;


✓




SELECT * FROM id;


| id1 |
| --: |
|  90 |


db&lt;&gt;fiddle here