ex:
CREATE TRIGGER mytrig AFTER INSERT OR UPDATE ON foo1 FOR EACH ROW EXECUTE
PROCEDURE updatefoo1('datarow');
The command itself is able to be executed without error. However, what then
happens, is that whenever the application attempts to insert a record into
foo1, it simply doesn't insert. Once I take the trigger off, it beings
inserting again.
I have checked permissions but INSERT only FAILS while trigger is enabled..
Thanks...Michelle
--
View this message in context: http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14282848.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.