Re: Inheritance and such

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.