Postgres Pro
Downloads
Home   >   mailing lists

BUG #13917: "upsert" construct doesn't work with partial index - Mailing list pgsql-bugs

From dv@unlimitedsoftware.it
Subject BUG #13917: "upsert" construct doesn't work with partial index
Date
Msg-id 20160204163146.2776.81824@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13917: "upsert" construct doesn't work with partial index  (Peter Geoghegan <pg@heroku.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13917
Logged by:          dante vitale
Email address:      dv@unlimitedsoftware.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.

pgsql-bugs by date:

Previous
From: reiner.peterke@splendiddata.com
Date:
Subject: BUG #13916: Only the install user can be defined in the new cluster
Next
From: xtracoder@gmail.com
Date:
Subject: BUG #13936: jsonb_object() -> ERROR: unknown type of jsonb container