[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: Update to whole table
From:       Steve Midgley <science () misuse ! org>
Date:       2021-06-03 13:55:40
Message-ID: CAJexoSJuP8hQqE_SSMkSLve9-SpXD27NUT3NHCskD+BDj=VtzQ () mail ! gmail ! com
[Download RAW message or body]

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

>

[Attachment #3 (text/html)]

<div dir="auto"><div><br><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Thu, Jun 3, 2021, 6:43 AM Yambu &lt;<a \
href="mailto:hyambu@gmail.com">hyambu@gmail.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr">Hello<br><div><br></div><div>If i \
run</div><div><br></div><div> update table set status_id=2 \
;</div><div><br></div><div>  and i stop it before it completes, will there be any \
updates done on some \
records?</div><div><br></div><div>regards</div></div></blockquote></div></div><div \
dir="auto"><br></div><div dir="auto">No. Postgres is acid which includes atomic - \
mean every statement either updates everything in its scope or nothing. Here&#39;s a \
link with a nice description: <a \
href="https://stackoverflow.com/questions/51728571/postgresql-acid-compliance">https://stackoverflow.com/questions/51728571/postgresql-acid-compliance</a> \
</div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> \
</blockquote></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]