Обсуждение: Update to whole table

If i run

update table set status_id=2 ;

 and i stop it before it completes, will there be any updates done on some records?

regards

No. Postgres is acid which includes atomic - mean every statement either updates everything in its scope or nothing. Here's a link with a nice description: https://stackoverflow.com/questions/51728571/postgresql-acid-compliance