help on delete trigger.

Поиск

Список

Период

Сортировка

От	Sundararajan
Тема	help on delete trigger.
Дата	14 августа 2001 г. 08:58:00
Msg-id	033501c11f00$5f9a8df0$3d0210ac@arula обсуждение исходный текст
Ответы	Re: [GENERAL] help on delete trigger.
Список	pgsql-novice

Дерево обсуждения

I am developing a db application in postgresql and i need to write a delete trigger on one of the tables.

the environment is

table1

field1 varchar(64)

other fields.

table 2.

field1 varchar(64)

other fields

I need a delete trigger on the table 1, so that if I delete a row from table 1 , the corresponding rows from table 2 should also be deleted.

This is the code I have tried.

DROP FUNCTION ApplicationsDeleteFn();
CREATE FUNCTION ApplicationsDeleteFn()
RETURNS OPAQUE
AS '
BEGIN
delete from ports where appName=OLD.appName;
RETURN OLD;

END;
'
LANGUAGE 'plpgsql';

Please help me with this, as my work is time bound.

Thanks

sundar

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

help on delete trigger.