If table have an inclusion with LIKE what happens to triggers?

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

Responses

Browse pgsql-general by date

  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.