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

[Sim Zacks <sim@xxxxxxxxxxxxxx>]

Ow Mun Heng wrote:

-----Original Message-----
From: gsstark@xxxxxxxxx [mailto:gsstark@xxxxxxxxx] On Behalf Of Greg Stark
  

On Tue, Jul 21, 2009 at 11:25 PM, Ow Mun Heng<ow.mun.heng@xxxxxxx> wrote:
   RETURN NULL;
      

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

Dang it.. I just re-read the online docs this morning and I missed it. 
Then again, since I'm new to triggers, I may have mis-interpreted that.

Thanks for it. I'll give it a go.

I agree that is certainly one problem, but in any case an After Update trigger would have worked.