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