Re: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

[Alexander Farber <alexander.farber@xxxxxxxxx>]

Even the simpler INSERT statement 

INSERT INTO stats(uid, single_q_left)

SELECT player1, COUNT(*)

FROM games

WHERE hand1 = '{Q}'

GROUP BY player1

ON CONFLICT(uid) DO NOTHING;

produces the same error.

On Sat, May 5, 2018 at 4:49 PM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote:

 http://sqlfiddle.com/#!17/7e929/13