On Tue, Jul 21, 2009 at 11:25 PM, Ow Mun Heng<ow.mun.heng@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general