What would cause this trigger:
create trigger log_trigger
before insert on log
for each row
execute procedure update_host_table();
to only fire on the first insert per connection, but none of the subsequent inserts?
The trigger runs fine, the procedure it calls runs fine, but it only executes the
trigger once per connection.
Thanks,
Fran