Re: Update to whole table

From: Steve Midgley <science(at)misuse(dot)org>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Update to whole table
Date: 2021-06-03 13:55:40
Message-ID: CAJexoSJuP8hQqE_SSMkSLve9-SpXD27NUT3NHCskD+BDj=VtzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jun 3, 2021, 6:43 AM Yambu <hyambu(at)gmail(dot)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

>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Yambu 2021-06-15 10:59:21 function INPUT as whole table
Previous Message Yambu 2021-06-03 13:43:09 Update to whole table