Postgres 11

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 TEST (ID int, NAME text);

CREATE TABLE

REVOKE ALL ON TABLE TEST FROM CURRENT_USER;
GRANT INSERT ON TABLE TEST TO CURRENT_USER;
GRANT SELECT ON TABLE TEST TO CURRENT_USER;

REVOKE

GRANT

GRANT

INSERT INTO TEST VALUES (1, 'NAME 1'),(2, 'NAME 2');

INSERT 0 2

UPDATE TEST SET NAME='NAME 3' WHERE ID = 1;

ERROR:  permission denied for table test