My Notes

  • Can we do anything about UNLESS CONFLICT can not use ELSE when constraint is from a parent type?
    • Surfaced 3x this week: Yury’s feedback and two Discord users

Meeting Notes

  • On UNLESS CONFLICT with ELSE when constraint is from a parent type
    • Don’t send IDs from client; security issue (Paul)
    • Won’t be fixed until 4.0 at least
    • What behavior would people want?
    • Real pain point that should be addressed
    • Write a guide to share Scott’s solution
    • Workarounds:
      • Insert with unless conflict with update that filters on the insert having failed.
  • Probably pushing the release another week (6/22)