Trigger only firing once

Поиск
Список
Период
Сортировка
Искать
От
Fran Fabrizio
Тема
Trigger only firing once
Дата
в 12:30:14
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 по дате отправления
От: John Coers
Дата:
Сообщение: Re: COPY locking
От: Ian Harding
Дата:
Сообщение: ALTER TABLE ADD CONSTRAINT
FAQ