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

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: If table have an inclusion with LIKE what happens to triggers?
Дата	14 декабря 2017 г. 01:57:12
Msg-id	CAKFQuwYXtoDLoVKm6v5S+XL6owRh70-uo3c91vmGO6cZNvy-5g@mail.gmail.com обсуждение исходный текст
Ответ на	If table have an inclusion with LIKE what happens to triggers? (Göran Hasse <gorhas@gmail.com>)
Список	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.

В списке pgsql-general по дате отправления:

От: John R Pierce
Дата: 14 декабря 2017 г., 01:38:09
Сообщение: Re: PostgreSQL Client on SUSE Enterprise Linux Server 11.

От: chiru r
Дата: 14 декабря 2017 г., 04:40:53
Сообщение: PgBackRest question?