Returning NEW in an on-delete trigger

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Returning NEW in an on-delete trigger
Дата
Msg-id 4abad0eb0809181121g625cb397qbd40ece12afecd7a@mail.gmail.com
обсуждение исходный текст
Ответы Re: Returning NEW in an on-delete trigger  (Jeff Davis <pgsql@j-davis.com>)
Re: Returning NEW in an on-delete trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Recently I discovered a coding error of mine in a trigger that is called only for deletes.

I was returning NEW instead of OLD. 

Since NEW is undefined when deleting a row, it was failing and the row wasn't being deleted.

However, it was failing silently.  Shouldn't this have recorded an error or warning somewhere?
--
Mike Nolan

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Running initdb while logged in as Administrator user (Windows)
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Returning NEW in an on-delete trigger