Re: [GENERAL] UPDATE ... ON CONFLICT DO NOTHING - Mailing list pgsql-general

​​

Have you tried with inner block and do nothing on exception;

 

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