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.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to