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 newtable (id int);

CREATE TABLE


ALTER TABLE newtable
    ADD COLUMNS f1 float8, f2 int; 

ERROR:  syntax error at or near "float8"
LINE 2:     ADD COLUMNS f1 float8, f2 int; 
                           ^


ALTER TABLE newtable
    ADD COLUMN f1 float8, f2 int, f3 text;

ERROR:  syntax error at or near "f2"
LINE 2:     ADD COLUMN f1 float8, f2 int, f3 text;
                                  ^


ALTER TABLE newtable
    ADD COLUMN f1 float8,
    ADD COLUMN f2 int,
    ADD COLUMN f3 text;

ALTER TABLE