Trigger Procedures question

Поиск
Список
Период
Сортировка
От Jean-Francois Leveque
Тема Trigger Procedures question
Дата
Msg-id 20010703125901.24325.qmail@webmails.com
обсуждение исходный текст
Ответы Re: Trigger Procedures question  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-hackers
I want to check something before
a delete is made.

I made a before delete trigger that
calls a procedure.

The procedure raises an exception
when I don't want the delete to be
made (I could also have returned NULL,
but wouldn't have get much information
from it).


The question is :
What do I return when I want the delete to be made ?

If I return OLD (known when deleting), maybe that
cancels the delete too.

I don't have NEW (known only on insert/update).

I couldn't find the answer in the docs.


Best regards,

Jean-Francois Leveque


______________________________________________________________________
Sur WebMailS.com, mon adresse de courrier �lectronique gratuite.
Service multilingue, s�r, et permanent. http://www.webmails.com/


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

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: selecting from cursor
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: selecting from cursor