Re: Trigger only firing once

Tom Lane wrote:
> Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net> writes:
> >> Kinda hard to believe.
>
> > I know it, but that's what I am seeing..... (to recap, my trigger only
> > fires on the first insert per connection.)
>
> > [snip]
>
> > ******* Here is the server log this time around *******
>
> > 2001-05-14 12:02:54 DEBUG: StartTransactionCommand
> > 2001-05-14 12:02:54 DEBUG: query: insert into log values
> > (0,0,lower(''),lower(''),lower(''),lower('hostname.changed.com'),upper('Med'),
> > upper('Apps'), upper('Medssld'), upper('INFO'), '1 medssld(s) running.',
> > '20010513 00:00:00');
> > 2001-05-14 12:02:54 DEBUG: ProcessQuery
> > 2001-05-14 12:02:54 DEBUG: CommitTransactionCommand
>
> > ****** Note, NO TRIGGER firing! So I disconnect and reconnect.... *****
>
> This does NOT show that no trigger fired. What it shows is that no
> queries within the trigger needed to be recompiled. The log entries
> you are looking at come from the parser when a query is compiled, not
> from plpgsql execution.
>
> Try adding some "raise NOTICE" or "raise DEBUG" messages to your trigger
> procedure to see what's really happening.
>
> (Yes, I know that plpgsql could do with some better tracing/debugging
> facilities than it's got. Any volunteers out there?)

Hands off please. I have some drastic changes to PL/pgSQL
outstanding that'll implement *real* cursor support. I'll
look at tracing while at it. Stay tuned...

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com