Re: Trigger definition . . . puzzled

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rolf A(dot) de By" <deby(at)itc(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Trigger definition . . . puzzled
Date: 2007-12-13 16:33:53
Message-ID: 13236.1197563633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Rolf A. de By" <deby(at)itc(dot)nl> writes:
> Yes, this is an inheritance set-up. But actually no: I am executing all
> my data changes against the parent table, and want the trigger on that
> parent table to fire for an insert on the parent table as it does. But
> I also want the trigger to fire when an update on the parent table is
> executed, and this does not happen.

There is no update on any row in the parent table. The update is on a
row in a child table.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rolf A. de By 2007-12-13 20:22:14 Re: Trigger definition . . . puzzled
Previous Message Rolf A. de By 2007-12-13 15:59:43 Re: Trigger definition . . . puzzled