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?
Дата
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?
 
​No
​
 
Or must I place triggers on all tables?

​Yes​
​

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

​​https://www.postgresql.org/docs/10/static/sql-createtable.html

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 по дате отправления: