search

supabase / postgrest-js

Isomorphic JavaScript client for PostgREST.
https://supabase.com
MIT License
965 stars 129 forks source link

Upserts do not seem to work on partial index on postgres #403

Open steve-chavez opened 1 year ago

steve-chavez commented 1 year ago

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 commented 1 month ago

hi hi any updates on this?

bragagia commented 3 weeks ago

Same issue on my side