Trigger only firing once
От
Fran Fabrizio
Тема
Trigger only firing once
Дата
Msg-id
3AFBF8DC.758B5D@exchange.webmd.net
Список
Дерево обсуждения
Re: Trigger only firing once Fran Fabrizio <ffabrizio@Exchange.WebMD.net>
Re: Trigger only firing once Tom Lane <tgl@sss.pgh.pa.us>
Re: Trigger only firing once Jan Wieck <JanWieck@Yahoo.com>
Anyone have any clues as to my question yesterday re: why my trigger only fires on the first insert per connection? After posting yesterday, I tried a few different things, but the only thing that works (and obviously not the most efficient thing to do) is to disconnect and reconnect after every insert. This trigger is: create trigger log_trigger before insert on log for each row execute procedure update_host_table(); The trigger runs fine, the procedure it calls runs fine, but it only executes the trigger once per connection. The odd thing is that I generated the trigger and the procedure from a text file of sql which hasn't changed in weeks. It worked perfectly in postgresql 7.0, but now that I think about it, I can't confirm it ever working correctly in 7.1 since I upgraded earlier in the week. Thanks, Fran
В списке pgsql-general по дате отправления