If table have an inclusion with LIKE what happens to triggers?
От
Göran Hasse
Тема
If table have an inclusion with LIKE what happens to triggers?
Дата
Msg-id
CADGsKJE9XKXqqVDPDn55mezH8+nr3nLF-hGmbChJrCjeU9jR8Q@mail.gmail.com
Список
Дерево обсуждения
If table have an inclusion with LIKE what happens to triggers? Göran Hasse <gorhas@gmail.com>
Re: If table have an inclusion with LIKE what happens to triggers? "David G. Johnston" <david.g.johnston@gmail.com>
Hello,
If I have a small table with common fields(
)
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;
$$
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();
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
В списке pgsql-general по дате отправления