Re: INSERT or UPDATE TRIGGER

"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> I am poking in the dark here.  What I want to do is to determine if
> the trigger is firing and whether the function works as intended.
> At the moment I am not seeing anything show up in the secondary
> table so I have done something wrong.  Is there some way of getting
> PG to tell me what it is doing?

You might find it more useful to add some elog(LOG) statements to the
trigger body.

            regards, tom lane