Re: Inheritance and such

On Fri, Apr 01, 2005 at 09:51:25AM -0600,
 John Hughes <johnh@wetleads.com> wrote
 a message of 49 lines which said:

> I ran into a brick wall when I realized that inheritance in postgres
> isnt really there...

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?

PostgreSQL  7.4