Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Дата
Msg-id CAADeyWi+=QecCjNu8krpwAQmeJirN_1L0BohaAFYh6RPaZpk4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Антон Тарабрин
Дата:
Сообщение: Re: [GENERAL] Table not cleaning up drom dead tuples
Следующее
От: Durumdara
Дата:
Сообщение: Re: [GENERAL] Maximum of connections in PG