Postgres 10

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 ttable 
(
  tcol numeric,
  constraint check_tcol_scale check (scale(tcol) <= 4)
);

CREATE TABLE


-- this fails
insert into ttable values (123.45678);

ERROR:  new row for relation "ttable" violates check constraint "check_tcol_scale"
DETAIL:  Failing row contains (123.45678).


-- this succeeds
insert into ttable values (123.4567);

INSERT 0 1