Le 28/03/2011 11:18, Guillaume Lelarge a écrit :
Le 28/03/2011 10:52, Francois Legrand a écrit :
They are fired as many times as needed.
That's my understanding... but it seems it doesn't always act like this !
There's no configuration that would explain that behaviour. My guess is
that you
Le 28/03/2011 10:52, Francois Legrand a écrit :
> Hi all,
> Are triggers are fired "only once by connection" ?
They are fired as many times as needed.
> 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 c
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
Absolutely !
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 tr
You're right. I run psql directly on the database host and access this
database using pgadmin from a remote machine. I could try to run pgadmin
on the same computer too, but I am pretty sure that it won't change the
result.
The strange point is that if I open the table using "view content of the
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 ?
>
A
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 ?
F.
-
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 ?
F.
-
