Re: Row insertion w/ trigger to another table update causes row insertion to _not_ occur

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Row insertion w/ trigger to another table update causes row insertion to _not_ occur
Дата
Msg-id 407d949e0907211612g78612566y7095cb8bcef2ed48@mail.gmail.com
обсуждение исходный текст
Ответ на Row insertion w/ trigger to another table update causes row insertion to _not_ occur  ("Ow Mun Heng" <ow.mun.heng@wdc.com>)
Ответы Re: Row insertion w/ trigger to another table update causes row insertion to _not_ occur
Список pgsql-general
On Tue, Jul 21, 2009 at 11:25 PM, Ow Mun Heng<ow.mun.heng@wdc.com> wrote:
>    RETURN NULL;


From the docs:
"It can return NULL to skip the operation for the current row."
-- http://www.postgresql.org/docs/current/static/trigger-definition.html

Just make your trigger return NEW and it won't kill the insert to the
child table.

--
greg
http://mit.edu/~gsstark/resume.pdf

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: element from an array by its index
Следующее
От: "Ow Mun Heng"
Дата:
Сообщение: Re: Row insertion w/ trigger to another table update causes row insertion to _not_ occur