I don't have personal experience with this, but I thought it was fairly common to DEFER constraint checking until after a restore completed, for exactly this reason.

- John Burger
  MITRE



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to