If table have an inclusion with LIKE what happens to triggers? - Mailing list pgsql-general

Then I put som triggers on those fields

CREATE OR REPLACE FUNCTION update_modified_timestamp_function() RETURNS trigger AS
$$
BEGIN
NEW.modified_timestamp := CURRENT_TIMESTAMP;
RETURN NEW;
END;
$$
LANGUAGE plpgsql VOLATILE;

CREATE TRIGGER common_field_update_triger
BEFORE UPDATE ON rscada.common_fields
FOR EACH ROW
EXECUTE PROCEDURE update_modified_timestamp_function();

And then include this in another table

CREATE TABLE venue

(

     name varchar default '',

     LIKE common_fields

)

The triggers is not executed.

Is there any way to inherit also

the triggers from the common_field table?

Or must I place triggers on all tables?

/Cordially yours

--