"James B. Byrne" <byrnejb(at)harte-lyne(dot)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