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?.
version |
---|
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
2 rows affected
10 rows affected
1 rows affected
1 rows affected
date_id | date_value | date_type | unknown_value |
---|---|---|---|
1 | 2021-09-15 | type_a | null |
2 | 2021-10-12 | null | :none |
ERROR: new row for relation "dates" violates check constraint "one_null"
DETAIL: Failing row contains (3, 2021-10-12, type_b, :tba).
ERROR: new row for relation "dates" violates check constraint "one_null"
DETAIL: Failing row contains (4, 2021-11-22, null, null).