Re: Row insertion w/ trigger to another table update causes row insertion to _not_ occur - Mailing list 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