Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

tablecmds.c

Blame
    • Robert Haas's avatar
      31b6fc06
      Fix inheritance count tracking in ALTER TABLE .. ADD CONSTRAINT. · 31b6fc06
      Robert Haas authored
      Without this patch, constraints inherited by children of a parent
      table which itself has multiple inheritance parents can end up with
      the wrong coninhcount.  After dropping the constraint, the children
      end up with a leftover copy of the constraint that is not dumped
      and cannot be dropped.  There is a similar problem with ALTER TABLE
      .. ADD COLUMN, but that looks significantly more difficult to
      resolve, so I'm committing this fix separately.
      
      Back-patch to 8.4, which is the first release that has coninhcount.
      
      Report by Hank Enting.
      31b6fc06
      History
      Fix inheritance count tracking in ALTER TABLE .. ADD CONSTRAINT.
      Robert Haas authored
      Without this patch, constraints inherited by children of a parent
      table which itself has multiple inheritance parents can end up with
      the wrong coninhcount.  After dropping the constraint, the children
      end up with a leftover copy of the constraint that is not dumped
      and cannot be dropped.  There is a similar problem with ALTER TABLE
      .. ADD COLUMN, but that looks significantly more difficult to
      resolve, so I'm committing this fix separately.
      
      Back-patch to 8.4, which is the first release that has coninhcount.
      
      Report by Hank Enting.