Postgres 16

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 "fooeyBar" (fooeyNumber INTEGER);

CREATE TABLE

insert into Fooeybar (fooeyNUmber) VALUES (325)

ERROR:  relation "fooeybar" does not exist
LINE 1: insert into Fooeybar (fooeyNUmber) VALUES (325)
                    ^

select fooeyNumber from fOOEYBAR;

ERROR:  relation "fooeybar" does not exist
LINE 1: select fooeyNumber from fOOEYBAR;
                                ^