Re: [GENERAL] Help with transactions

2005-03-21 Thread Stephen Howie
2(table1_id, newdata3); IF table2_id > 0 THEN RETURN TRUE; ELSE RETURN FALSE; END IF; END; ' LANGUAGE plpgsql SECURITY DEFINER; END=== Also, in my original schema I'm getting an increment of 2 every time I run nextval. I can't dup

[GENERAL] Help with transactions

2005-03-18 Thread Stephen Howie
fail if the trigger fails? To me that defeats the purpose of having a trigger after insert. Thanks for any help -- - Stephen Howie begin:vcard fn:Stephen Howie n:Howie;Stephen email;internet:[EMAIL PROTECTED] tel;work:260-760-5910 tel;fax:260-436-9472 tel;cell:260-704-6262