Postgres 9.5

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 tbl (field1 int, "FIELD2" int, field3 int);

CREATE TABLE

insert into tbl values (1,2,3),(4,5,6);

INSERT 0 2

select field1, field2, field3 from tbl;

ERROR:  column "field2" does not exist
LINE 1: select field1, field2, field3 from tbl;
                       ^
HINT:  Perhaps you meant to reference the column "tbl.field1" or the column "tbl.field3".

select field1, "FIELD2", field3 from tbl;

field1
FIELD2
field3

1
2
3

4
5
6

SELECT 2