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 t(
    a varchar(30) 
    default 'abc'
    not null
);

CREATE TABLE


-- checking what the column looks like...
select table_name, column_name, column_default, is_nullable, character_maximum_length
from information_schema.columns
where table_name = 't';


table_name
column_name
column_default
is_nullable
character_maximum_length


t
a
'abc'::character varying
NO
30



SELECT 1


 -- let me innocently expand the varchar len 
alter table t
alter column a type varchar(40);

ALTER TABLE


-- and checking what the column looks like again...
-- it's fine. totally fine.
select table_name, column_name, column_default, is_nullable, character_maximum_length
from information_schema.columns
where table_name = 't';


table_name
column_name
column_default
is_nullable
character_maximum_length


t
a
'abc'::character varying
NO
40



SELECT 1