Hi all,<br /> Are triggers are fired "only once by connection" ?<br /> Here is my point.<br /><br /> I found a really
strangebehaviour of the pgadmin II with triggers.<br /> I activated the detailed logs on my server thus I could monitor
everything,and the point is the following :<br /><br /> 1) I open the query tool<br /> 2) I do a first insert in my
table==> The trigger is fired<br /> 3) I do a second (and more) insert in my table ==> The trigger is NOT fired
<br/> 4) I close the query tool and open it again and do an insert ==> the trigger is fired<br /><br /> Thus it
appearsthat when I run several inserts from the query tool, the trigger is fired the first time but not anymore
after.<br/> I found that this is exactly the same if I add lines directly from the "Edit data" window. The first line I
addfire the trigger, but the others no.<br /><br /> Moreover, it is also the same from the psql tool. <br /> I open
psql,do an insert : the trigger is fired. But if I do a second insert, the trigger is not fired.<br /><br /><b>Thus it
appearsthat triggers are fired "only once by connection" !</b><br /><br /> I found that someone had the same problem
(<aclass="moz-txt-link-freetext"
href="http://www.mail-archive.com/pgsql-general@postgresql.org/msg23094.html">http://www.mail-archive.com/pgsql-general@postgresql.org/msg23094.html</a>)<br
/><br/> Is that normal ? Is it possible to fix that in the server configuration ?<br /><br /> I would appreciate some
feedbackon this issue !<br /> Thanks in advance<br /><br /> F.<br /><br /><br /><br /><br /><br /> Le 25/03/2011 18:48,
GuillaumeLelarge a écrit : <blockquote cite="mid:4D8CD589.4000404@lelarge.info" type="cite"><pre wrap="">Le 25/03/2011
17:54,Francois Legrand a écrit :
</pre><blockquote type="cite"><pre wrap="">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 ?
</pre></blockquote><pre wrap="">
</pre></blockquote>