On 6/8/20 5:42 AM, Laura Smith wrote:
Hi, What'st the current state of play with indexes and ON CONFLICT ? The docs seem to vaguely suggest it is possible, but this SO 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 it in a function ? ON CONFLICT (index_name) .... : does not work ON CONFLICT ON CONSTRAINT index_name....: does not work
The above is going to need more information: 1) Table definition. 2) Actual index definition 3) Complete ON CONFLICT definition 4) Error message returned. -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
