Postgres 12

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 tab1(id INT,
                      PRIMARY KEY (id) CONSTRAINT PK_tab1
                      -- here the CONSONSTRAINT is after PRIMARY KEY def
);
ERROR:  syntax error at or near "CONSTRAINT"
LINE 2:                       PRIMARY KEY (id) CONSTRAINT PK_tab1
                                               ^


CREATE TABLE tab2(id INT,
                  CONSTRAINT PK_tab2  PRIMARY KEY (id) 
);
CREATE TABLE tab3(id INT,  
                 CHECK(id > 10) CONSTRAINT CHK_tab3_id 
);
ERROR:  syntax error at or near "CONSTRAINT"
LINE 2:                  CHECK(id > 10) CONSTRAINT CHK_tab3_id 
                                        ^