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

CREATE TABLE

INSERT 0 1

ERROR:  column "txn_timestamp" is of type timestamp with time zone but expression is of type text
LINE 24: SELECT id, mid, txn_timestamp, cre_ts
                         ^
HINT:  You will need to rewrite or cast the expression.