Answer the question
In order to leave comments, you need to log in
old entry not set to postgresql?
I have a function
create function tr_ar_skl() returns trigger
language plpgsql
as
$$
begin
raise notice 'old: %', old;
insert into "arcSklad" (id_sklad, date_plan, fact_prodaj, id_arc_plan, plan_postav, fact_postav, plan_prodaj) VALUES
(old.id_sklad, old.date_plan, old.fact_prodaj, old.id_plan, old.plan_postav, old.fact_postav, old.plan_prodaj);
end;
$$;
alter function tr_ar_skl() owner to postgres;
create trigger trigger_skl
before delete
on "objPSklad"
execute procedure tr_ar_skl();
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question