Re: New addition to the merge sql standard

2023-11-20 Thread Nick DeCoursin
> "ignore" may not be what you want, though. Perhaps the fact that insert > (coming from the NOT MATCHED clause) fails (== conflicts with a tuple > concurrently inserted in an unique or exclusion constraint) should > transform the row operation into a MATCHED case, so it'd fire the other > clauses

Re: New addition to the merge sql standard

2023-11-16 Thread Alvaro Herrera
On 2023-Nov-16, Nick DeCoursin wrote: > In my opinion, it would be better for merge to offer the functionality to > simply ignore the rows that cause unique violation exceptions instead of > tanking the whole query. "ignore" may not be what you want, though. Perhaps the fact that insert (coming