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

Reply via email to