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 test (jsonb_value JSONB CHECK (jsonb_value::text ~ '^{"en": "[^"]+", "ru": "[^"]+"}$'));
insert into test values 
('{"en": "value", "ru": "значение"}');
1 rows affected

insert into test values 
('{"ru": "значение", "en": "value"}');
1 rows affected

insert into test values 
('{"en": 6, "ru": "значение"}');
ERROR:  new row for relation "test" violates check constraint "test_jsonb_value_check"
DETAIL:  Failing row contains ({"en": 6, "ru": "значение"}).


insert into test values 
('{"en": "", "ru": "значение"}');
ERROR:  new row for relation "test" violates check constraint "test_jsonb_value_check"
DETAIL:  Failing row contains ({"en": "", "ru": "значение"}).


insert into test values 
('{"en": "value", "ru": "значение", "fr": "de valuje"}');
ERROR:  new row for relation "test" violates check constraint "test_jsonb_value_check"
DETAIL:  Failing row contains ({"en": "value", "fr": "de valuje", "ru": "значение"}).