Re: pgsql: Allow FOR EACH ROW triggers on partitioned tables

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pgsql: Allow FOR EACH ROW triggers on partitioned tables
Дата
Msg-id 20180325050145.exr5xfnihpj3dly5@alap3.anarazel.de
обсуждение исходный текст
Ответ на pgsql: Allow FOR EACH ROW triggers on partitioned tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: pgsql: Allow FOR EACH ROW triggers on partitioned tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-committers
Hi,

On 2018-03-23 13:48:53 +0000, Alvaro Herrera wrote:
> Allow FOR EACH ROW triggers on partitioned tables
> 
> Previously, FOR EACH ROW triggers were not allowed in partitioned
> tables.  Now we allow AFTER triggers on them, and on trigger creation we
> cascade to create an identical trigger in each partition.  We also clone
> the triggers to each partition that is created or attached later.
> 
> This means that deferred unique keys are allowed on partitioned tables,
> too.
> 
> Author: Álvaro Herrera
> Reviewed-by: Peter Eisentraut, Simon Riggs, Amit Langote, Robert Haas,
>         Thomas Munro
> Discussion: https://postgr.es/m/20171229225319.ajltgss2ojkfd3kp@alvherre.pgsql

The inherit.sql here looks like it's racing against the concurrentlys
scheduled triggers.sql according to my new desmoxytes animal:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=desmoxytes&dt=2018-03-25%2004%3A48%3A01

Greetings,

Andres Freund


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Add long options to pg_resetwal and pg_controldata
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: pg_resetwal: Fix logical typo in code