Home > mailing lists

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

From	David G. Johnston
Subject	Re: If table have an inclusion with LIKE what happens to triggers?
Date	December 14, 2017 01:57:12
Msg-id	CAKFQuwYXtoDLoVKm6v5S+XL6owRh70-uo3c91vmGO6cZNvy-5g@mail.gmail.com Whole thread Raw
In response to	If table have an inclusion with LIKE what happens to triggers? (Göran Hasse <gorhas@gmail.com>)
List	pgsql-general

On Wed, Dec 13, 2017 at 11:21 AM, Göran Hasse <gorhas@gmail.com> wrote:

Is there any way to inherit also
the triggers from the common_field table?

Or must I place triggers on all tables?

Yes

The docs cover what is able to be copied and triggers are not mentioned.

Mostly column-related things are copied, not table-related things (e.g., table comments, triggers, policies)

I suspect its mostly a lack of need warranting the effort than any fundamental design reason.

David J.

From: John R Pierce
Date: 14 December 2017, 01:38:09
Subject: Re: PostgreSQL Client on SUSE Enterprise Linux Server 11.

From: chiru r
Date: 14 December 2017, 04:40:53
Subject: PgBackRest question?