Re: trigger on DELETE

Поиск
Список
Период
Сортировка
От Kristis Makris
Тема Re: trigger on DELETE
Дата
Msg-id 200107112323.f6BNNra16872@postgresql.org
обсуждение исходный текст
Ответ на trigger on DELETE  (Phuong Ma <pma@commandprompt.com>)
Список pgsql-sql
> Ok, the function works only with a trigger that is defined as ON INSERT
> OR UPDATE.  If I try to define a trigger for ON DELETE and then delete a
> row from the table, there is nothing in the 'NEW' variable to return.  I
> get an error message.  If I define the function to return NULL, 0, or
> nothing, then it comes up with a type mis-match error.  Is there anyone
> who can help?  Thanks.


Try using the OLD variable instead.



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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: [GENERAL] trigger on DELETE
Следующее
От: Wei Weng
Дата:
Сообщение: Turn off flushing after each write