Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with trigger - Mailing list pgsql-novice

From Rikard Bosnjakovic
Subject Re: Help with trigger
Date
Msg-id AANLkTimVdH8+O9JqyTiOWdgHWTMFyoGXJBDbN62QcaXp@mail.gmail.com
Whole thread Raw
In response to Re: Help with trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
On Sun, Aug 15, 2010 at 07:21, Tom Lane <tgl@sss.pgh.pa.us> wrote:

[...]
> From your verbal description I wonder if you shouldn't have the trigger
> on components instead.

Adding a trigger ON UPDATE on the components table solved the problem
- dimensions are now purged automatically as soon as the components
are updated.

Thanks.


--
- Rikard

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help with trigger
Next
From: Leon Starr
Date:
Subject: How to trap invalid enum input exception?