I have tried to set a flag ('deleted' ) instead of actual record deletion, so I have tried to accomplish it with next piece of code in the trigger:

BEGIN

** Description: disable deletion of the rows from the table,

** instead we set .deleted flag to 1

IF (TG_OP = 'DELETE') THEN

UPDATE v.comps SET deleted = 1 WHERE v.comps.id = OLD.id;

RETURN NULL;

END IF;

END;

DELETE row on the table v does not generate any error, but row still here and 'deleted' field has not been set to 1 as expected.

So, what I'm need to check ?

TIA.