From: | Göran Hasse <gorhas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | If table have an inclusion with LIKE what happens to triggers? |
Date: | 2017-12-13 18:21:50 |
Message-ID: | CADGsKJE9XKXqqVDPDn55mezH8+nr3nLF-hGmbChJrCjeU9jR8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
If I have a small table with common fields
CREATE TABLE common_filelds
(
created_timestamp timestamp,
updated_timestamp timestamp
)
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
--
gorhas(at)gmail(dot)com
Göran Hasse
Boo 229
715 91 ODENSBACKEN
Mob: 070-5530148
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Finzel | 2017-12-13 18:39:57 | Re: Dependency tree to tie type/function deps to a table |
Previous Message | PAWAN SHARMA | 2017-12-13 17:58:26 | PostgreSQL Client on SUSE Enterprise Linux Server 11. |