Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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)
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.
