IGNORE

With the IGNORE modifier, the UPDATE statement does not abort even if errors occur during execution.

Input

# IGNORE 
UPDATE IGNORE employees SET department_id=3;

Output

-- IGNORE 
UPDATE "public"."employees" SET "department_id" = 3;