PostgreSQL trigger function executing multiple times

Question

i am experimenting with triggers in postgreSQL, but the trigger insert i would like to make is being done twice for some reason(THIS IS USING THE FOR EACH ROW), when i changed it to FOR EACH STATEMENT it was executing the insert 3 times. this is my sql script

CREATE OR REPLACE FUNCTION forest_aud_func() returns trigger as $tree_stamp$ 
BEGIN
    insert into Audit values('k',124,'l');
    return null;
END;
$tree_stamp$
LANGUAGE plpgsql;

create trigger forest_aud_ins after insert on forest
for each row execute procedure forest_aud_func()

insert into forest values('Blue',1600,'Austria','Health Ltd')

any idea why this is happening? Thanks

You should not return null from your trigger. That will stop processing the insert! — user330315
– user330315, Commented Jan 11, 2012 at 12:27
it still does the insert for me with return null, i don't think its the problem, or did you mean something else? — Karl
– Karl, Commented Jan 11, 2012 at 12:38
this is strange, because the manual clearly states that the insert (in your case the insert into forest) will be aborted if the trigger returns null. — user330315
– user330315, Commented Jan 11, 2012 at 13:09

Karl · Accepted Answer · 2012-01-11 12:48:25Z

2

i found out the problem, i was always creating new triggers but not deleting the previous ones, so each time i do an insert it was firing all the triggers i had done, sorry and thanks for your help

answered Jan 11, 2012 at 12:48

Karl

7812 gold badges9 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

Thanks for giving the feedback.

Collectives™ on Stack Overflow

PostgreSQL trigger function executing multiple times

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related