Answer the question
In order to leave comments, you need to log in
Will the transaction end with update if there is an error in the called procedure?
There is a table equipment_status
. A trigger has been created for it:
CREATE TRIGGER "trg_eq_statuses_techtracker"
AFTER UPDATE ON public.equipment_status FOR EACH ROW
EXECUTE PROCEDURE trg_eq_statuses_techtracker()
trg_eq_statuses_techtracker()
that calls a procedure eq_statuses_techtracker()
that may fail (trying to put a message into RabbitMQ). eq_statuses_techtracker()
an error occurs in? Will the transaction be rolled back?
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