Transition tables for column-specific UPDATE triggers

Guy Burgess <guy@xxxxxxxxxxxxx> · Wed, 9 Oct 2019 15:59:33 +1300



    Hello,

    
    The manual says:
      https://www.postgresql.org/docs/current/sql-createtrigger.html
    
      A column list cannot be specified when requesting transition
        relations.
    
    And (I think the same point):

    
      The standard allows transition tables to be used with
        column-specific UPDATE triggers,
        but then the set of rows that should be visible in the
        transition tables depends on the trigger's column list. This is
        not currently implemented by PostgreSQL.
    
    Are there any plans to allow transition tables to be used with
      column-specific UPDATE triggers?  Or, is there another way for a
      trigger function to see the rows changed by a column-specific
      UPDATE trigger?

    
    Thanks