Re: UPDATE ... ON CONFLICT DO NOTHING

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: UPDATE ... ON CONFLICT DO NOTHING
Date: 2017-03-14 16:00:36
Message-ID: CAADeyWi+=QecCjNu8krpwAQmeJirN_1L0BohaAFYh6RPaZpk4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My initial idea has been not to use ON CONFLICT at all, but instead only
UPDATE the words_reviews records (set "uid" or "author" to out_uid) for
which NO EXISTS already such a record with PK (uid, author)... and then
DELETE the rest (as I can't update them without a conflict) but I haven't
figured it out yet...

Thank you anyway

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2017-03-14 16:08:47 Re: Maximum of connections in PG
Previous Message Антон Тарабрин 2017-03-14 15:55:51 Re: Table not cleaning up drom dead tuples