Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table DEMO (n int);

CREATE TABLE

begin transaction;

BEGIN

insert into DEMO values (0);

INSERT 0 1

select n "after insert" from DEMO;

after insert

0

SELECT 1

savepoint just_before_the_statement;

SAVEPOINT

update DEMO set n=1/n;

ERROR:  division by zero

rollback to just_before_the_statement;

ROLLBACK

select n "after error" from DEMO;

after error

0

SELECT 1

commit;

COMMIT

select n "after commit" from DEMO;

after commit

0

SELECT 1