Triggers called twice, triggers debugging

From: pdvluca(at)gmail(dot)com (pdvluca)
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers called twice, triggers debugging
Date: 2004-07-14 14:08:12
Message-ID: 3b732a5a.0407140608.5d18a7f2@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm quite new to postgresql, so please forgive me if these are stupid
questions, but I couldn't find answers.

I'm using versione 7.3.4 (i can't upgrade, sorry).

I've written a trigger function using C to export update query results
to a Java program. The trigger seems to work except that it's being
called twice for each tuple updated.

This is what I used

CREATE TRIGGER myTrig AFTER UPDATE on myTable FOR EACH ROW EXECUTE
PROCEDURE trigFunction();

The trigger is quite simple right now, but it's going to become
complex, so I'd like to know how to deug it, I've tried to attach to
postmaster process and to psql without succeding, is there any guide
for triggers debugging?

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-14 14:31:44 Re: Function and RowType
Previous Message Carlos Roberto Chamorro Mostacilla 2004-07-14 13:14:47 Re: Function and RowType