Postgres 9.6

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?.

select version()


version


PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Debian 9.6.11-1.pgdg80+1), compiled by gcc (Debian 4.9.2-10+deb8u1) 4.9.2, 64-bit


create table test_temporal (
  id SERIAL,
  name varchar(16)
);

create or replace function test_temporal_insert()
returns trigger as $$
begin
INSERT INTO test_temporal ( id, name )
values (  DEFAULT , new.name );
return NEW;
end;
$$ language plpgsql;
insert into test_temporal ( name ) values ( 'a' );
1 rows affected

select * from test_temporal;


id
name


1
a