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
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
Is that normal ? Is it possible to fix that in the server configuration ?
I would appreciate some feedback on this issue !
Thanks in advance
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 ?
In response to
pgadmin-support by date
|Next:||From: Guillaume Lelarge||Date: 2011-03-28 09:18:33|
|Subject: Re: Triggers in pgadmin query tools|
|Previous:||From: Wells Oliver||Date: 2011-03-28 05:13:16|
|Subject: pgAdmin3 1.12.2 on OSX - showing multiple postgres servers that don't exist?|