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

2018-03-26 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera writes: > > Andres Freund wrote: > >> 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

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

2018-03-26 Thread Tom Lane
Alvaro Herrera writes: > Andres Freund wrote: >> 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 > You're right

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

2018-03-26 Thread Alvaro Herrera
Andres Freund wrote: > On 2018-03-23 13:48:53 +, Alvaro Herrera wrote: > > Allow FOR EACH ROW triggers on partitioned tables > The inherit.sql here looks like it's racing against the concurrentlys > scheduled triggers.sql according to my new desmoxytes animal: > https://buildfarm.postgresql.o

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

2018-03-24 Thread Andres Freund
Hi, On 2018-03-23 13:48:53 +, 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

pgsql: Allow FOR EACH ROW triggers on partitioned tables

2018-03-23 Thread Alvaro Herrera
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