On Sat, Sep 24, 2022 at 10:56 AM Christophe Pettus <x...@thebuild.com> wrote:
> > > > On Sep 24, 2022, at 08:49, Barry Kimelman <blkimel...@gmail.com> wrote: > > I thought the whole point of ON CONFLICT DO UPDATE was so that you could > modify the data so that it would be inserted > > ON CONFLICT DO UPDATE allows you to modify the existing row that > conflicted with the row being inserted, but it won't allow you to do change > a row to resolve a conflict, and then insert it. Unfortunately, that is exactly what I need to do, I need to modify the data on the 2nd request so that it also gets inserted. This is a business requirement. I need to insert all of the data, including the ones with conflicts
