update with no changes - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject update with no changes
Date
Msg-id CAB-JLwbvubZ17JEiHUrzyq=RvSYZ4cFeNtHkCM8ZDCCfuc328g@mail.gmail.com
Whole thread Raw
Responses Re: update with no changes
Re: update with no changes
List pgsql-hackers
Why this happens ?

create table t(i int);
CREATE TABLE
insert into t values(1);
INSERT 0 1
select (ctid::text::point)[1]::int, * from t;
 ctid | i
------+---
    1 | 1
(1 row)
update t set i = i;
UPDATE 1
select (ctid::text::point)[1]::int, * from t;
 ctid | i
------+---
    2 | 1
(1 row)

If nothing was changed, why create a new record, append data to wal, set old record as deleted, etc, etc ?

regards,
Marcos

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: A spot of redundant initialization of brin memtuple
Next
From: Bharath Rupireddy
Date:
Subject: Re: Shouldn't postgres_fdw report warning when it gives up getting result from foreign server?