Re: [GENERAL] CANNOT USE ANY INDEX ON UPSERT (INSERT.....ON CONFLICT)

2017-04-18 Thread agharta
Hi, Thank you for your suggestion, i'll try to implement it. Many thanks, Cheers, Agharta Il 18/04/2017 12:38, Alban Hertroys ha scritto: On 18 Apr 2017, at 10:13, agharta wrote: Hi all, I have a problem with INSERT ... ON CONFLICT sql command. Reading 9.6 documentation i see th

[GENERAL] CANNOT USE ANY INDEX ON UPSERT (INSERT.....ON CONFLICT)

2017-04-18 Thread agharta
-slow-performance select count in before insert/update trigger). In this case i can't create any type of primary/unique index, like a composite F1,F2, F3, F4 index. (correct me if i am wrong please). So, how to use UPSERT in this case? Best regards, Agharta