On 19 May 2015 at 21:57, Simon Riggs <simon@2ndquadrant.com> wrote:It's not clear to me how a single INSERT could cause two or more UPDATEs. CREATE TABLE mytable ( c1 int NOT NULL, c2 int NOT NULL, PRIMARY KEY (c1), UNIQUE (c2) );INSERT INTO mytable (c1, c2) (10, 20);INSERT INTO mytable (c1, c2) (11, 21);INSERT INTO mytable (c1, c2) (10, 21) ON CONFLICT DO UPDATE .....Or did you mean from a coding point of view how it would be possible to implement?
It's not clear to me how a single INSERT could cause two or more UPDATEs.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных