BUG #13917: "upsert" construct doesn't work with partial index

From: dv(at)unlimitedsoftware(dot)it
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13917: "upsert" construct doesn't work with partial index
Date: 2016-02-04 16:31:46
Message-ID: 20160204163146.2776.81824@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13917
Logged by: dante vitale
Email address: dv(at)unlimitedsoftware(dot)it
PostgreSQL version: 9.5.0
Operating system: centos 6
Description:

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-02-04 17:54:56 Re: BUG #13909: String concat error with CITEXT after 9.5.0 upgrade.
Previous Message Daniel Verite 2016-02-04 16:25:17 Re: BUG #13911: pg_upgrade from 8.4 to 9.5 broken