Hi All!
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.
--
С уважением,
Ruslan R. Laishev
OpenVMS bigot, natural born system/network progger, C contractor.
+79013163222
+79910009922