T
T
TemaKam2021-04-03 17:16:05
PostgreSQL
TemaKam, 2021-04-03 17:16:05

How to NOT interrupt trigger execution after RAISE statement? Or how else to display the message?

I use an INSTEAD OF row-level trigger, the field of each row is checked, and if it does not match the condition, then you need to display a message, but do not interrupt the trigger and do not roll back the transaction.
Can this be done with RAISE at all?
Or do I need to display messages differently in this case?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
galaxy, 2021-04-03
@TemaKam

RAISE NOTICEwhat does not work?

F
freeExec, 2021-04-03
@freeExec

No way. Just as it is impossible not to terminate the program, but only to send the exit code from the program.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question