Re: INSERT or UPDATE TRIGGER - Mailing list pgsql-general

From Tom Lane
Subject Re: INSERT or UPDATE TRIGGER
Date
Msg-id 20836.1239134859@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT or UPDATE TRIGGER  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Responses Re: INSERT or UPDATE TRIGGER
List pgsql-general
"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

pgsql-general by date:

Previous
From: Cha Yang
Date:
Subject: tables filled to 1 Gig each
Next
From: "James B. Byrne"
Date:
Subject: Re: INSERT or UPDATE TRIGGER