Postgres 16

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 check (
  id INT NOT NULL PRIMARY KEY,
);

ERROR:  syntax error at or near "check"
LINE 1: CREATE TABLE check (
                     ^


CREATE TABLE pay_transaction (
  id INT NOT NULL PRIMARY KEY,
);

ERROR:  syntax error at or near ")"
LINE 3: );
        ^


CREATE TABLE payment_type (
  id INT NOT NULL PRIMARY KEY,
);

ERROR:  syntax error at or near ")"
LINE 3: );
        ^


CREATE TABLE pay_info (
  id INT NOT NULL PRIMARY KEY,
);

ERROR:  syntax error at or near ")"
LINE 3: );
        ^


INSERT INTO check(id, good_id, date)
VALUES 
  (1, 1, '2004-11-11 11:11:11'),
  (2, 2, '2005-11-11 11:11:11'),
  (3, 3, '2005-11-11 11:11:11');

ERROR:  syntax error at or near "check"
LINE 1: INSERT INTO check(id, good_id, date)
                    ^