Upserts do not seem to work on partial index on postgres

[steve-chavez]

Discussed in https://github.com/supabase/supabase/discussions/12565

^{Originally posted by beacoding February 20, 2023} Looks like we cannot specify an onConflict and where together when we set a partial index on our postgres db.

We end up getting a unique or exclusion constraint matching the ON CONFLICT when a partial index is used and we specify the key to use it for.

The solution to fix this is to filter on the index_predicate, but the client does not allow us to do this https://stackoverflow.com/questions/42022362/no-unique-or-exclusion-constraint-matching-the-on-conflict

Are there any plans to support upserts of partial indices?

[beagreenlite]

hi hi any updates on this?

[bragagia]

Same issue on my side

[lxup]

Same issue, any update ?

[amerryma]

I'd love to see this. In the meantime, does anyone have any workarounds?