Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: there is no unique or exclusion constraint matching the ONCONFLICT specification - Mailing list pgsql-general

From Alexander Farber
Subject Re: ERROR: there is no unique or exclusion constraint matching the ONCONFLICT specification
Date
Msg-id CAADeyWgfwDnFQ+wJo4eEPMnOOJgrrtQU6mNS4Xh40JqKy=0XRQ@mail.gmail.com
Whole thread Raw
In response to ERROR: there is no unique or exclusion constraint matching the ONCONFLICT specification  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:

pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: statement_timeout issue
Next
From: Adrian Klaver
Date:
Subject: Re: comparison between 2 execution plans