"INSERT ON CONFLICT UPDATE" - Use of indexes ?

Поиск
Список
Период
Сортировка
От Laura Smith
Тема "INSERT ON CONFLICT UPDATE" - Use of indexes ?
Дата
Msg-id D7XeBgJlPCvQJTomQlRtQ9xXe12qS4v-wYACle-TpfLfsbsdCWd_7SXqFOPJdpiW444JlClvQkREVxJyUA_Avy6BCASy7sDxDOshXw6a8Es=@protonmail.ch
обсуждение исходный текст
Ответы Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?
Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?
Re: "INSERT ON CONFLICT UPDATE" - Use of indexes ?
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Laura Smith
Дата:
Сообщение: Re: Postgres 12 RLS
Следующее
От: Ron
Дата:
Сообщение: Re: When to use PARTITION BY HASH?