Re: Triggers in pgadmin query tools

Hi all,
Are triggers are fired "only once by connection" ?
Here is my point.

I found a really strange behaviour of the pgadmin II with triggers.
I activated the detailed logs on my server thus I could monitor
everything, and the point is the following :

1) I open the query tool
2) I do a first insert in my table ==> The trigger is fired
3) I do a second (and more) insert in my table ==> The trigger is NOT fired
4) I close the query tool and open it again and do an insert ==> the
trigger is fired

Thus it appears that when I run several inserts from the query tool, the
trigger is fired the first time but not anymore after.
I found that this is exactly the same if I add lines directly from the
"Edit data" window. The first line I add fire the trigger, but the
others no.

Moreover, it is also the same from the psql tool.
I open psql, do an insert : the trigger is fired. But if I do a second
insert, the trigger is not fired.

*Thus it appears that triggers are fired "only once by connection" !*

I found that someone had the same problem
(http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg23094.html)

Is that normal ? Is it possible to fix that in the server configuration ?

I would appreciate some feedback on this issue !
Thanks in advance

F.

Le 25/03/2011 18:48, Guillaume Lelarge a écrit :
> Le 25/03/2011 17:54, Francois Legrand a écrit :
>> Hi all,
>> I have a table with a trigger. When I run an insert command from psql,
>> the trigger is correctly fired, but if i run exactly the same command
>> from the pgqdmin3 query tool, the trigger is not fired !
>> Is that normal ?
>> Any clue ?
>>