On 2017/08/02 4:02, Robert Haas wrote: > On Tue, Aug 1, 2017 at 12:26 AM, Amit Langote > <langote_amit...@lab.ntt.co.jp> wrote: >> So is the latest patch posted upthread to process ON CONFLICT DO NOTHING >> using locally-defined unique indexes on leaf partitions something to >> consider? > > Yeah, for v11.
OK. >> Maybe, not until we have cascading index definition working [1]? > > Not sure what that has to do with it. Hmm, scratch that. I was thinking that if all partitions had uniformly defined (unique) indexes, the behavior on specifying on conflict do nothing would be consistent across all partitions, but I guess that's not a really big win or anything. Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers