• Alvaro Herrera's avatar
    Allow FOR EACH ROW triggers on partitioned tables · 86f57594
    Alvaro Herrera authored
    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
    86f57594
oidjoins.out 34.5 KB