Postgres Pro
Downloads
Home   >   mailing lists

"INSERT ON CONFLICT UPDATE" - Use of indexes ? - Mailing list pgsql-general

From Laura Smith
Subject "INSERT ON CONFLICT UPDATE" - Use of indexes ?
Date
Msg-id D7XeBgJlPCvQJTomQlRtQ9xXe12qS4v-wYACle-TpfLfsbsdCWd_7SXqFOPJdpiW444JlClvQkREVxJyUA_Avy6BCASy7sDxDOshXw6a8Es=@protonmail.ch
Whole thread Raw
Responses Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?  (Thomas Kellerer <shammat@gmx.net>)
Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
Tree view 
Hi,

What'st the current state of play with indexes and ON CONFLICT ?  The docs seem to vaguely suggest it is possible, but
thisSO question (https://stackoverflow.com/questions/38945027/) seems to suggest it is not. 

I've got a unique named index on a table (i.e. "create unique index xyz...") but I cannot seem to be able to refer to
itin a function ? 
ON CONFLICT (index_name) .... : does not work
ON CONFLICT ON CONSTRAINT index_name....: does not work

pgsql-general by date:

Previous
From: Laura Smith
Date:
Subject: Re: Postgres 12 RLS
Next
From: Ron
Date:
Subject: Re: When to use PARTITION BY HASH?