Trigger only firing once

From: Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger only firing once
Date: 2001-05-11 14:36:12
Message-ID: 3AFBF8DC.758B5D@exchange.webmd.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2001-05-11 14:56:39 Re: How to create a trigger
Previous Message Philip Crotwell 2001-05-11 14:26:49 defunct postmasters