On Thu, Feb 4, 2016 at 8:31 AM, <dv(at)unlimitedsoftware(dot)it> wrote:
> an INSERT ... ON CONFLICT DO NOTHING statement doesn't twork if unique index
> on duplicated field is created without "where" clause. In case of co called
> "partial index" the duplicate key exception rises.
Please provide a concrete test case. I think you just need to spell
out the WHERE clause in the inference specification. That will use
both indexes (the partial unique index, as well as the non-partial
unique index on the same fields).
--
Peter Geoghegan