An update rule affecting an after insert trigger

From: Simrin Grewal <simrin(at)simrin(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: An update rule affecting an after insert trigger
Date: 2005-08-27 18:08:26
Message-ID: 4310AC1A.2090005@simrin.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey Folks,

Scratching my head on this one wanted to know if anyone else had
encounter it.

I have a table that has an update rule and an after insert trigger on
it. The rule checks to see if certain things happened during the update
and goes and does another insert to a secondary table. The trigger is
an after insert trigger to call a stored plpgsql function. The problem
I am seeing is that I cannot get the trigger to fire. I did a simple
test just to verify that triggers are working in general and they are
but nothing for this one. I have even intentionally broken the stored
procedure just to see if I was making it to that logic but nothing. Does
anyone know what might cause this to occur?

Simrin Grewal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-08-27 19:13:21 Re: POSS. FEATURE REQ: "Dynamic" Views
Previous Message Chris Travers 2005-08-27 18:03:10 Re: Postgresql replication