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)