Request a Demo
Home   >   mailing lists

Re: Update to whole table - Mailing list pgsql-sql

From Steve Midgley
Subject Re: Update to whole table
Date
Msg-id CAJexoSJuP8hQqE_SSMkSLve9-SpXD27NUT3NHCskD+BDj=VtzQ@mail.gmail.com
Whole thread Raw
In response to Update to whole table  (Yambu <hyambu@gmail.com>)
List pgsql-sql
Tree view


On Thu, Jun 3, 2021, 6:43 AM Yambu <hyambu@gmail.com> wrote:
Hello

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 

pgsql-sql by date:

Previous
From: Yambu
Date:
Subject: Update to whole table
Next
From: Yambu
Date:
Subject: function INPUT as whole table