Postgres 14

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 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit


create table test_nu(vp_id integer, system_activ text, vpm_activ text) ;
insert into test_nu(vp_id, system_activ, vpm_activ) VALUES('{"vp_id": 1,"system_activ":"eewrw","vpm_activ":"qeqerqr"}');
ERROR:  INSERT has more target columns than expressions
LINE 1: insert into test_nu(vp_id, system_activ, vpm_activ) VALUES('...
                                   ^


insert into test_nu(vp_id, system_activ, vpm_activ)
  select * from json_populate_recordset(
  NULL::test_nu,'[{"vp_id": 1,"system_activ":"eewrw","vpm_activ":"qeqerqr"}
  ,{"vp_id":2,"system_activ":"record-2","vpm_activ":"activ-record-2"}]')
2 rows affected

select * from test_nu;


vp_id
system_activ
vpm_activ


1
eewrw
qeqerqr

2
record-2
activ-record-2