Postgresql - Is calling a stored procedure in a trigger possible?

Question

I would like to call a stored procedure using a trigger in Postgresql. Is it possible?

Here is an example:

create table foo(n int primary key, n1 int);     

create or replace procedure set_column_value(value int)
language plpgsql
:as $$
begin
 update foo
 set n1 = id
commit;
end;$$

The trigger would be something like: After insert or update on foo, call the stored procedure set_column_value(new.n)

Answer 1

No, a trigger needs to call a trigger function. But there is nothing that keeps you from writing a PL/pgSQL trigger function that CALLs the procedure of your liking.