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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING
Дата
Msg-id CAKFQuwb-XCeQO4gt4p0SGYEAunZugP3T4DBTLsbqUPAo1giZmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING  (Yasin Sari <yasinsari81@googlemail.com>)
Ответы Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING  (Alexander Farber <alexander.farber@gmail.com>)
Список pgsql-general
The convention on these lists is to inline or bottom-post.

On Tue, Mar 14, 2017 at 12:07 PM, Yasin Sari <yasinsari81@googlemail.com> wrote:
​​
Have you tried with inner block and do nothing on exception;


​I suppose that would work - though using an exception path for expected logic is messy - and considerably slower than detection.

After doing something like this the OP would then want to DELETE any remaining records that still have the uid or author with the old value.  Do nothing by itself would just leave them alone.​

 
BEGIN

 <your code>
..............
         BEGIN
         
          UPDATE words_social 
                SET uid = out_uid
                WHERE uid = ANY(_uids);

         EXCEPTION WHEN OTHERS THEN
            --do nothing or write NULL means do nothing
   

​David J.​

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

Предыдущее
От: Stuart Bishop
Дата:
Сообщение: Re: [GENERAL] Postgres backup solution
Следующее
От: Todd Vitello
Дата:
Сообщение: [GENERAL] Test to pgsql-general@postgresql.org