Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group