> update master_items set "feedback_to_de" = 'Yes' >--Query returned successfully: 591268 rows affected, 1589335 ms execution time.
Here you should better use update master_items set feedback_to_de = 'Yes' WHERE feedback_to_de <> 'Yes' OR update master_items set feedback_to_de <> 'Yes' WHERE feedback_to_de IS DISTINCT FROM 'Yes' depending on the column nullable. regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
