Re: Triggers not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dale Harris" <itsupport(at)jonkers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Triggers not working
Date: 2008-09-23 03:43:20
Message-ID: 16950.1222141400@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dale Harris" <itsupport(at)jonkers(dot)com(dot)au> writes:
> The trigger trAccountUpdate got called, but why didn't the trigger
> trEntityUpdate get called?

Triggers only apply to the exact table they're declared on, not
to child tables.

It does seem like there might be some use-case for applying a trigger to
child tables too, but that's not how it works now.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dale Harris 2008-09-23 03:56:25 Re: Triggers not working
Previous Message Tom Lane 2008-09-23 03:02:28 Re: Help with query to return indexes (including functional ones!) on a given table