Re: Statement-level triggers and inheritance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Subject: Re: Statement-level triggers and inheritance
Date: 2008-11-29 17:42:29
Message-ID: 2328.1227980549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> On Friday 28 November 2008 16:59:19 Tom Lane wrote:
>> My feeling is that it ought to fire such triggers on *each* target.

> This would amount to statement level triggers firing multiple times per
> statement wouldn't it?

No, because they'd be different triggers. A trigger on a parent table
has got nothing to do with triggers on children.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-11-29 19:41:20 Re: WIP: Hash Join-Filter Pruning using Bloom Filters
Previous Message Robert Treat 2008-11-29 17:37:26 Re: Statement-level triggers and inheritance