[NOVICE] trigger on delete/field update

Поиск

Список

Период

Сортировка

От	Ruslan R. Laishev
Тема	[NOVICE] trigger on delete/field update
Дата	16 октября 2017 г. 17:27:38
Msg-id	1880941508164058@web15o.yandex.ru обсуждение исходный текст
Ответы	Re: [NOVICE] trigger on delete/field update
Список	pgsql-novice

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

В списке pgsql-novice по дате отправления: