From: | Daniel Schuchardt <daniel_schuchardt(at)web(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Inheritance and such |
Date: | 2005-04-03 20:43:20 |
Message-ID: | d2pkgm$1n1s$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Stephane Bortzmeyer schrieb:
>
>I have a problem which MAY be in the same category.
>
>CREATE TABLE base (
> id serial not null primary key,
> <some base columns>
>);
>
>CREATE TABLE specialized (
><some specialized columns>
>) INHERITS base;
>
>Now, I try to set up a trigger AFTER UPDATE ON base but, when I update
>"specialized", the trigger is not called. Same thing with CREATE or
>DELETE. I have to define the trigger to be AFTER UPDATE ON
>specialized. Is it normal?
>
>
>
Yes, thats known.
You have to define a trigger on each child table. You can point that
trigger on the same function.
Daniel.
From | Date | Subject | |
---|---|---|---|
Next Message | Karl O. Pinc | 2005-04-03 21:05:37 | Strange plpgsql performance -- arithmetic, numeric() type, arrays |
Previous Message | Stephane Bortzmeyer | 2005-04-03 20:12:45 | Re: Inheritance and such |