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.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
