Re: Delete triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete triggers
Дата
Msg-id 28449.1049382288@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Delete triggers  ("Mathew Frank" <mathewfrank@qushi.com>)
Список pgsql-bugs
"Mathew Frank" <mathewfrank@qushi.com> writes:
> The documentation on this is very thin on the ground - I`ve just spend 4 Ho=
> urs googling and the best I could find was one of the main developers (Bruc=
> e?? sorry - too long ago) replying to an email in 2001.    Which was to NOT=
>  cancel the delete operation, you need to return NEW or OLD.

There is no NEW row in a delete trigger.  RETURN OLD should work.

>  - If I return OLD the operation is cancelled ("DELETE 0").

I suspect pilot error.

            regards, tom lane

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

Предыдущее
От: "Mathew Frank"
Дата:
Сообщение: Delete triggers
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Bug #931: bugs "create user" "alter user"